Re: [ADMIN] audit trail for viewed data

2011-10-28 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I have been asked to investigate creating an > "audit trail" for viewed data. ... > My first pass attempt at a solution was to use a set returning > function that inserted to the audit trail... ... > I'm sure this has to do with the function

Re: [ADMIN] pgbench-tools for Windows

2011-10-28 Thread Dimitri Fontaine
Jelena Gorelikova writes: Could you tell me, how to set up (step by step) pgbench-tools on Windows 7 for PostgreSQL 9.0? is it possible? How could I test PostgreSQL scalability (scaling up and elasticity)? Is it possible to do on the Windows platform? I don't know about pgbench-tools on win

Re: [ADMIN] How to find and/or REINDEX only GiST indexes in the database?

2011-10-28 Thread Dimitri Fontaine
"Gnanakumar" writes: > My question is, how do I find out or REINDEX *only* GiST indexes in the > database? Is there a single syntax/command that does this? You might find this article useful: http://tapoueh.org/blog/2010/08/05-querying-the-catalog-to-plan-an-upgrade.html Regards, -- Dimitr