Re: [ADMIN] [GENERAL] Time of previous REINDEX execution..

2007-05-08 Thread Jeff Davis
y need to know, a REINDEX changes the relfilenode, so you can see the creation time of the file in the data directory corresponding to the current indexes of the table. That will probably be the last time REINDEX was run. Does that help? Regards, Jeff Davis ---

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-14 Thread Jeff Davis
Mac and Linux have a different notion of what en_US collation means (I couldn't find any standard anywhere to say that one was right and the other was wrong). So, that risks index corruption. Regards, Jeff Davis -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To mak