- secondary
when necessary, it only goes primary-secondary. I played with pgpool
for a while and came up with effectively the same confused question.
--
Jeff Hoffmann
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your
Oleg Bartunov wrote:
On Wed, 9 Mar 2005, Jeff Hoffmann wrote:
Oleg Bartunov wrote:
I'm experimenting with pgpool 2.51 on my Linux box runnung
two postgresql backends: pg74:5432 and pg801:5433
I configured pgpool to use pg74:5432 as primary backend and
pg801:5433 as second one. Pgpool is running
behavior as is or create a cycle switch in case the user preferred that
behavior.
--
Jeff Hoffmann
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
misreading what probably happened?
--
Jeff Hoffmann
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
be interested in following the development and helping
with testing.
--
Jeff Hoffmann
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
to think twice about downloading
through standard avenues or BT won't help you.
--
Jeff Hoffmann
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do
thing. I compiled a 7.4 beta out of
the box without a hitch, so I'd assume the RC would be fine as well.
--
Jeff Hoffmann
PropertyKey.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
to change it if it wasn't
appropriate. What more can you really do? At some point, the end user
has to bear some responsibility...
--
Jeff Hoffmann
PropertyKey.com
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
if you're not familiar with tiger, it's a street database
from the census department. you can find it at
ftp://ftp.linuxvc.com/pub/US-map. it's in plain text format, but
trivial to import. it's set up in several (at least a dozen tables)
which are heavily interrelated sometimes in fairly complex ways.