Leonia Zaj?c wrote:
> Li?cieHi !
>
> Can anybody say, HOW does the postgre sql query planer, or executer,
> prepers the query plan, if i have several indexes on my table ?
You can look at EXPLAIN to see the index chosen. I have an "Internals
through Pictures" PDF on my home page below that outli
Hi !
Can anybody say, HOW does the postgre sql query planer, or
executer, prepers the query plan, if i have several indexes on my table
?
Best Regards
Leo
Hi,
since some month we use PITR and it works fine. We make a base backup
once a week. For testing if everything will work when needed we replay
the wal files every day to the base backup on a second machine. It works
fine except for two time when we saw a strange problem. The recovery
process
Your best bet would be to query the system tables. Something like
SELECT definition FROM pg_views;
On Thu, Nov 03, 2005 at 12:43:47PM -0600, Randall Smith wrote:
> What is the most simple way to backup and restore only views?
>
> Randall
>
>
> ---(end of broadcast)-
Hi,
When using redirect_stderr = true the permissions of the resulting
logfile are 600 (owner and group are postgres). Is it possible to change
the permission to 640 or 660 (without recompiling postgres?)?
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-388
Hi,
Is it possible to log all the SELECT statements for a given
database.tablespace without setting "log_statement = all" and using some
sort of grep filter?
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail:
