postgres

Commit Graph

Author	SHA1	Message	Date
Robert Haas	06d7fd6e29	Update pg_buffercache extension for parallel query. The pg_buffercache_pages function provided by this extension is PARALLEL SAFE. Andreas Karlsson	9 years ago
Andres Freund	f57791985a	Add pinning_backends column to the pg_buffercache extension. The new column shows how many backends have a buffer pinned. That can be useful during development or to diagnose production issues e.g. caused by vacuum waiting for cleanup locks. To handle upgrades transparently - the extension might be used in views - deal with callers expecting the old number of columns. Reviewed by Fujii Masao and Rajeev rastogi.	11 years ago
Tom Lane	458857cc9d	Throw a useful error message if an extension script file is fed to psql. We have seen one too many reports of people trying to use 9.1 extension files in the old-fashioned way of sourcing them in psql. Not only does that usually not work (due to failure to substitute for MODULE_PATHNAME and/or @extschema@), but if it did work they'd get a collection of loose objects not an extension. To prevent this, insert an \echo ... \quit line that prints a suitable error message into each extension script file, and teach commands/extension.c to ignore lines starting with \echo. That should not only prevent any adverse consequences of loading a script file the wrong way, but make it crystal clear to users that they need to do it differently now. Tom Lane, following an idea of Andrew Dunstan's. Back-patch into 9.1 ... there is not going to be much value in this if we wait till 9.2.	14 years ago
Tom Lane	029fac2264	Avoid use of CREATE OR REPLACE FUNCTION in extension installation files. It was never terribly consistent to use OR REPLACE (because of the lack of comparable functionality for data types, operators, etc), and experimentation shows that it's now positively pernicious in the extension world. We really want a failure to occur if there are any conflicts, else it's unclear what the extension-ownership state of the conflicted object ought to be. Most of the time, CREATE EXTENSION will fail anyway because of conflicts on other object types, but an extension defining only functions can succeed, with bad results.	15 years ago
Tom Lane	629b3af27d	Convert contrib modules to use the extension facility. This isn't fully tested as yet, in particular I'm not sure that the "foo--unpackaged--1.0.sql" scripts are OK. But it's time to get some buildfarm cycles on it. sepgsql is not converted to an extension, mainly because it seems to require a very nonstandard installation process. Dimitri Fontaine and Tom Lane	15 years ago
Peter Eisentraut	fc946c39ae	Remove useless whitespace at end of lines	15 years ago
Magnus Hagander	9f2e211386	Remove cvs keywords from all files.	15 years ago
Heikki Linnakangas	ef1c807c25	pg_buffercache needs to be taught about relation forks, as Greg Stark pointed out.	17 years ago
Bruce Momjian	33e2e02493	Add CVS version labels to all install/uninstall scripts.	18 years ago
Bruce Momjian	926bbab448	Make /contrib install/uninstall script consistent: remove transactions use create or replace function make formatting consistent set search patch on first line Add documentation on modifying *.sql to set the search patch, and mention that major upgrades should still run the installation scripts. Some of these issues were spotted by Tom today.	18 years ago
Bruce Momjian	b0194ab110	Add the usage count statistics to the information available in contrib/pgbuffercache. Greg Smith	19 years ago
Bruce Momjian	525de8d556	Improve /contrib/pg_buffercache installation to use BEGIN/COMMIT, improve examples. Mark Kirkwood	20 years ago
Peter Eisentraut	7f4f42fa10	Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in particular get rid of single quotes around language names and old WITH () construct.	20 years ago
Tom Lane	12a323b7a8	Change relblocknumber field of pg_buffercache view from numeric to int8 for efficiency's sake. Mark Kirkwood.	21 years ago
Neil Conway	de004e44e2	Add pg_buffercache contrib module, from Mark Kirkwood.	21 years ago

1 Commits (master)