summaryrefslogtreecommitdiff
path: root/contrib/pgstattuple
Commit message (Collapse)AuthorAgeFilesLines
* The functions bt_metap, bt_page_stats and bt_page_items had movedMagnus Hagander2007-06-071-48/+1
| | | | | | | from contrib/pgstattuple to pageinspect. We've already fixed English documentation, but Japanese version does not catch up. ITAGAKI Takahiro
* Add CVS comment for recent commit:Bruce Momjian2007-05-171-1/+1
| | | | | Moved page-level functions from pgstattuple to contrib/pageinspect.
* Add database page inspection /contrib module.Bruce Momjian2007-05-174-588/+42
| | | | Simon and Heikki
* Tweak hash index AM to use the new ReadOrZeroBuffer bufmgr API when fetchingTom Lane2007-05-031-2/+2
| | | | | | | pages it intends to zero immediately. Just to show there is some use for that function besides WAL recovery :-). Along the way, fold _hash_checkpage and _hash_pageinit calls into _hash_getbuf and friends, instead of expecting callers to do that separately.
* Clean up the representation of special snapshots by including a "methodTom Lane2007-03-251-3/+3
| | | | | | | | | | | | | | | | | | | | | pointer" in every Snapshot struct. This allows removal of the case-by-case tests in HeapTupleSatisfiesVisibility, which should make it a bit faster (I didn't try any performance tests though). More importantly, we are no longer violating portable C practices by assuming that small integers are distinct from all pointer values, and HeapTupleSatisfiesDirty no longer has a non-reentrant API involving side-effects on a global variable. There were a couple of places calling HeapTupleSatisfiesXXX routines directly rather than through the HeapTupleSatisfiesVisibility macro. Since these places had to be changed anyway, I chose to make them go through the macro for uniformity. Along the way I renamed HeapTupleSatisfiesSnapshot to HeapTupleSatisfiesMVCC to emphasize that it's only used with MVCC-type snapshots. I was sorely tempted to rename HeapTupleSatisfiesVisibility to HeapTupleSatisfiesSnapshot, but forebore for the moment to avoid confusion and reduce the likelihood that this patch breaks some of the pending patches. Might want to reconsider doing that later.
* Fix uninitialized value in pgstatindex leading to invalid values beingAlvaro Herrera2007-03-161-11/+6
| | | | | | reported in some cases. Report and patch from Tatsuhito Kasahara. Also fix a couple of other bugs I noticed in skimming the surrounding code.
* Simplify contrib Makefiles by removing unnecessary SRCS macro,Tom Lane2006-10-191-4/+2
| | | | per Magnus.
* pgindent run for 8.2.Bruce Momjian2006-10-041-97/+100
|
* Update Japanese readme for pgstattuple.Bruce Momjian2006-09-041-27/+103
|
* Clean up some leftover problems in pgstattuple: remove unwanted andTom Lane2006-09-044-93/+32
| | | | | unportable elog(NOTICE) report, fix install/uninstall sequence. Itagaki Takahiro
* Add functions to /contrib/pgstattuple that show index statistics andBruce Momjian2006-09-024-45/+919
| | | | | | index page contents. Satoshi Nagayasu
* Alphabetically order reference to include files, "N" - "S".Bruce Momjian2006-07-111-3/+3
|
* Add index information to /contrib/pgstattuple:Bruce Momjian2006-07-063-105/+430
| | | | | | | | | | | | | | This is an extension of pgstattuple to query information from indexes. It supports btree, hash and gist. Gin is not supported. It scans only index pages and does not read corresponding heap tuples. Therefore, 'dead_tuple' means the number of tuples with LP_DELETE flag. Also, I added an experimental feature for btree indexes. It checks fragmentation factor of indexes. If an leaf has the right link on the next adjacent page in the file, it is assumed to be continuous (not fragmented). It will help us to decide when to REINDEX. ITAGAKI Takahiro
* Magic blocks don't do us any good unless we use 'em ... so install oneTom Lane2006-05-301-1/+3
| | | | in every shared library.
* Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, inPeter Eisentraut2006-02-273-6/+6
| | | | | particular get rid of single quotes around language names and old WITH () construct.
* contrib uninstall scriptsPeter Eisentraut2006-02-272-1/+10
| | | | by David Fetter
* Standard pgindent run for 8.1.Bruce Momjian2005-10-151-6/+6
|
* PGXS should be set with := not =, as specified in the documentation,Tom Lane2005-09-271-2/+2
| | | | to avoid useless multiple executions of pg_config.
* Document get_call_result_type() and friends; mark TypeGetTupleDesc()Tom Lane2005-05-301-10/+12
| | | | | | and RelationNameGetTupleDesc() as deprecated; remove uses of the latter in the contrib library. Along the way, clean up crosstab() code and documentation a little.
* Remove second argument from textToQualifiedNameList(), as it is no longerNeil Conway2005-05-271-3/+2
| | | | used. From Jaime Casanova.
* Repair possible failure to update hint bits back to disk, perTom Lane2004-10-151-2/+9
| | | | | | | | | | http://archives.postgresql.org/pgsql-hackers/2004-10/msg00464.php. This fix is intended to be permanent: it moves the responsibility for calling SetBufferCommitInfoNeedsSave() into the tqual.c routines, eliminating the requirement for callers to test whether t_infomask changed. Also, tighten validity checking on buffer IDs in bufmgr.c --- several routines were paranoid about out-of-range shared buffer numbers but not about out-of-range local ones, which seems a tad pointless.
* Remove DROPs from contrib object creation scripts, per Dave Page.Tom Lane2004-10-011-1/+0
|
* Pgindent run for 8.0.Bruce Momjian2004-08-291-5/+5
|
* > Please find enclose a submission to fix these problems.Bruce Momjian2004-08-201-11/+14
| | | | | | | | | | | | | | | | | | | | | | > > The patch adds missing the "libpgport.a" file to the installation under > "install-all-headers". It is needed by some contribs. I install the > library in "pkglibdir", but I was wondering whether it should be "libdir"? > I was wondering also whether it would make sense to have a "libpgport.so"? > > It fixes various macros which are used by contrib makefiles, especially > libpq_*dir and LDFLAGS when used under PGXS. It seems to me that they are > needed to > > It adds the ability to test and use PGXS with contribs, with "make > USE_PGXS=1". Without the macro, this is exactly as before, there should be > no difference, esp. wrt the vpath feature that seemed broken by previous > submission. So it should not harm anybody, and it is useful at least to me. > > It fixes some inconsistencies in various contrib makefiles > (useless override, ":=" instead of "="). Fabien COELHO
* Get rid of rd_nblocks field in relcache entries. Turns out this wasTom Lane2004-05-081-2/+3
| | | | | | | | | costing us lots more to maintain than it was worth. On shared tables it was of exactly zero benefit because we couldn't trust it to be up to date. On temp tables it sometimes saved an lseek, but not often enough to be worth getting excited about. And the real problem was that we forced an lseek on every relcache flush in order to update the field. So all in all it seems best to lose the complexity.
* Replace TupleTableSlot convention for whole-row variables and functionTom Lane2004-04-011-7/+3
| | | | | | | | results with tuples as ordinary varlena Datums. This commit does not in itself do much for us, except eliminate the horrid memory leak associated with evaluation of whole-row variables. However, it lays the groundwork for allowing composite types as table columns, and perhaps some other useful features as well. Per my proposal of a few days ago.
* make sure the $Id tags are converted to $PostgreSQL as well ...PostgreSQL Daemon2003-11-292-2/+2
|
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* pgindent run.Bruce Momjian2003-08-041-2/+2
|
* Fix some minor portability issues, per Chris K-L.Tom Lane2003-08-011-7/+7
|
* New patch with corrected README attached.Bruce Momjian2003-06-123-12/+56
| | | | | | Also quickly added mention that it may be a qualified schema name. Rod Taylor
* Backend support for autocommit removed, per recent discussions. TheTom Lane2003-05-141-2/+0
| | | | | | only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-181-13/+18
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* Add GRANT EXECUTE ON FUNCTIONTatsuo Ishii2002-09-181-0/+1
|
* pgindent run.Bruce Momjian2002-09-041-24/+20
|
* Refrect changes made by Tom LaneTatsuo Ishii2002-09-041-5/+9
|
* Adjust nodeFunctionscan.c to reset transient memory context between callsTom Lane2002-08-293-73/+41
| | | | | | | to the table function, thus preventing memory leakage accumulation across calls. This means that SRFs need to be careful to distinguish permanent and local storage; adjust code and documentation accordingly. Patch by Joe Conway, very minor tweaks by Tom Lane.
* Adapt for SRF(Set Returning Function).Tatsuo Ishii2002-08-234-89/+196
|
* Restructure indexscan API (index_beginscan, index_getnext) perTom Lane2002-05-201-3/+3
| | | | | | | yesterday's proposal to pghackers. Also remove unnecessary parameters to heap_beginscan, heap_rescan. I modified pg_proc.h to reflect the new numbers of parameters for the AM interface routines, but did not force an initdb because nothing actually looks at those fields.
* Further cleanups for relations in schemas: teach nextval and otherTom Lane2002-03-303-8/+13
| | | | | | sequence functions how to cope with qualified names. Same code is also used for int4notin, currtid_byrelname, pgstattuple. Also, move TOAST tables into special pg_toast namespace.
* Change made to elog:Bruce Momjian2002-03-061-2/+2
| | | | | | | | | | | | | | | | | | | o Change all current CVS messages of NOTICE to WARNING. We were going to do this just before 7.3 beta but it has to be done now, as you will see below. o Change current INFO messages that should be controlled by client_min_messages to NOTICE. o Force remaining INFO messages, like from EXPLAIN, VACUUM VERBOSE, etc. to always go to the client. o Remove INFO from the client_min_messages options and add NOTICE. Seems we do need three non-ERROR elog levels to handle the various behaviors we need for these messages. Regression passed.
* Reflect Tom's changeTatsuo Ishii2001-12-201-4/+15
|
* Fix pgstattuple to acquire a read lock on the target table. ThisTom Lane2001-12-192-20/+38
| | | | | | prevents embarassments such as having the table dropped or truncated partway through the scan. Also, fix free space calculation to include pages that currently contain no tuples.
* pgindent run on all C files. Java run to follow. initdb/regressionBruce Momjian2001-10-251-73/+74
| | | | tests pass.
* Add pgstattupleTatsuo Ishii2001-10-015-0/+274
View Lorry Controller Status