(Posted to General a while back but perhaps this is a more appropriate
list since I got no responses. :)
How can I tell if writing to the WAL is a bottleneck? In other words,
how can I tell if upgrading the disk the WAL is on will improve
performance? (I do have the WAL on its own disk.)
Steve Santacroce [EMAIL PROTECTED] writes:
/usr/local/bin/pg_ctl -D /pgdata -l /var/log/pgsql
and nothing, postmaster still doesn't start!
You forgot the start keyword. I'm surprised pg_ctl fails to complain...
regards, tom lane
---(end of
Andrzej Schulz writes:
Hi, I would Like to get information abort tables existing In PostgreSQL
via PHP. I would like to know the names, their description and of
course how they are build.
http://www.postgresql.org/docs/7.3/static/catalogs.html
--
Peter Eisentraut [EMAIL PROTECTED]
Steve Santacroce writes:
chmod 600 ${logfile}
chown pgsql:pgsql ${logfile}
[ -x ${PGBIN}/pg_ctl ] {
su -l pgsql -c \
[ -d \${PGDATA} ] exec ${PREFIX}/bin/pg_ctl start -s -w -l
${logfile}
echo -n ' pgsql'
No errors, no messages, nothing. Then I
Archie MacDonald (rsh) writes:
I am following the instructions in the techdocs for solaris 8 ( see
link below) and I am trying to
instal readline 4.2a first. It has not went well so far ...:-(
You should probably ask in a forum dedicated to readline, not to
PostgreSQL.
--
Peter Eisentraut
On Mon, 25 Aug 2003, Jeff Boes wrote:
One action we have consiously not done is REINDEX on the
table. We want to avoid that as far as possible.
Why? It's usually a very painless step, unless the table has millions and
millions of rows. We reindex tables with multiple indexes and several
On Fri, Aug 22, 2003 at 12:09:00PM -0700, Vikram D. Gaitonde wrote:
One action we have consiously not done is REINDEX on the
table. We want to avoid that as far as possible.
I'm afraid that's the problem, though. The code cannot recover freed
btree pages which can't be recycled for others to
chmod 600 ${logfile}
chown pgsql:pgsql ${logfile}
[ -x ${PGBIN}/pg_ctl ] {
su -l pgsql -c \
[ -d \${PGDATA} ] exec ${PREFIX}/bin/pg_ctl
start -s -w -l
${logfile}
echo -n ' pgsql'
No errors, no messages, nothing. Then I tried to start
Hi, we really want to get a reliable PostgreSQL replication
setup going, with a Master Write server and many Slave Read-Only
servers replicating off the master. This is to allow us to
scale up our low-write/high-read application over many customers.
We've done some research (ie, web searching)
Yes the variable is actually: PGPASSWORD
I have a crond pg_dump script (as root) that sets this variable and
dumps with -U postgres and uses the variable successfully.
(7.2.4).
Cheers
CM
Stephan Szabo wrote:
On Sun, 24 Aug 2003, Jesse Burkhardt wrote:
I am sure many of you have encountered the
Hi List,
I'm looking for a way to force an Index to be used in a SQL query. In a
Oracle SQL query it would be like:
Select /*+ my_index*/ * from my_table where my_name=rhaoni;
So it would use the index my_index to execute the query. How can I make this
in a PostgreSQL SQL query.
Hi List,
I'm looking for a way to force an Index to be used in a SQL query. In a
Oracle SQL query it would be like:
Select /*+ my_index*/ * from my_table where my_name=rhaoni;
So it would use the index my_index to execute the query. How can I make this
in a PostgreSQL SQL query.
On Tue, Aug 26, 2003 at 16:11:56 -0300,
Rhaoni Chiu Pereira [EMAIL PROTECTED] wrote:
Hi List,
I'm looking for a way to force an Index to be used in a SQL query. In a
Oracle SQL query it would be like:
Select /*+ my_index*/ * from my_table where my_name=rhaoni;
So it
At 03:47 PM 8/25/2003, Jonathan Ellis wrote:
(Posted to General a while back but perhaps this is a more appropriate
list since I got no responses. :)
How can I tell if writing to the WAL is a bottleneck? In other words, how
can I tell if upgrading the disk the WAL is on will improve
On Tue, Aug 26, 2003 at 06:19:12PM +0100, Chris Miles wrote:
eRServer
http://www.erserver.com/
Commercial, looks professional. Not free.
However, No trial or evaluation ?
There's (about to be?) a free version available now. If you start
grovelling around on gborg some time late this
15 matches
Mail list logo