Is it possible to query another database while in 'psql' with another database?
-
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
DJ Pichay написа:
> Is it possible to query another database while in 'psql' with another
> database?
http://www.postgresql.org/docs/faqs.FAQ.html#item4.17
--
Milen A. Radev
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, pl
Hi,
On Dienstag, 18. Dezember 2007, Alvaro Herrera wrote:
| A.Burbello wrote:
| > If doesn't have another way, how can I put the
| > "header" in the begin of file without open?
| > With "cat >>" command I put in the end.
|
| Don't -- you can put the header in a separate file and do something like
Hi,
we are running a PostgreSQL server (8.2.4) which is used for our internet
service and use log file shipping to get a near-real-time backup.
As the hardware for the backup database server is quite expensive we would
like to use it for internal reporting purposes. That's why we have done the
f
Hi,
We have two PostgreSQL 8.2 database servers: A master and a warm-standby
server. We plan on making an initial backup of the master onto the standby
and then use log-shipping with "real-time" WAL-file processing as described
in http://www.postgresql.org/docs/8.2/static/warm-standby.html
My qu
"David F. Skoll" <[EMAIL PROTECTED]> writes:
> My question is this: If the master database is fairly busy, gets
> VACUUMed once a day, etc. can we expect the warm standby server
> to work correctly after days/weeks/months/years of log shipping,
> or should we periodically take new base backups?
I
I see a lot of suggestions to increase maintenance work mem if running
pg_restore. This is to help with the index creation and initial sort from
what I understand. A few tests I ran does show this helps.
Does anyone know if there is a way to only "temporarily" set this setting?
I have some DBs th
Deron escribió:
> I see a lot of suggestions to increase maintenance work mem if running
> pg_restore. This is to help with the index creation and initial sort from
> what I understand. A few tests I ran does show this helps.
> Does anyone know if there is a way to only "temporarily" set this set
On Dec 18, 2007 2:30 PM, Deron <[EMAIL PROTECTED]> wrote:
> I see a lot of suggestions to increase maintenance work mem if running
> pg_restore. This is to help with the index creation and initial sort from
> what I understand. A few tests I ran does show this helps.
> Does anyone know if there i
Deron <[EMAIL PROTECTED]> writes:
> Does anyone know if there is a way to only "temporarily" set this setting?
Aside from the specific answers already given, the general answer is to
read
http://www.postgresql.org/docs/8.2/static/config-setting.html
which enumerates all (most?) of the many ways yo
Hello,
My purpose is to uses different query plan depending on queries
I got the following problem : some queries are taking too much time and
postgresql does not take the most relevant index in account.
I search on internet and found that no HINT function was available in
postgresl.
I tried to
Thanks for this and the other suggestions. This is exactly what I was
looking for.
Deron
On 12/18/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> Deron escribió:
> > I see a lot of suggestions to increase maintenance work mem if running
> > pg_restore. This is to help with the index creatio
On Dec 18, 2007 4:21 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> My purpose is to uses different query plan depending on queries
> I got the following problem : some queries are taking too much time and
> postgresql does not take the most relevant index in account.
> I search on i
Scott Marlowe a écrit :
On Dec 18, 2007 4:21 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Hello,
My purpose is to uses different query plan depending on queries
I got the following problem : some queries are taking too much time and
postgresql does not take the most relevant index in acc
14 matches
Mail list logo
