I found this tool pretty helpful for validating my architectural decisions..
http://www.howfuckedismydatabase.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit of
difference.. I've tried restarting postgres, deleting all the
existing logs, etc. No
Mike Christensen, 27.08.2010 11:39:
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit of
difference.. I've tried restarting postgres, deleting
Yup, someone emailed me privately - this fixed the problem.. Thanks!
On Fri, Aug 27, 2010 at 2:55 AM, Thomas Kellerer spam_ea...@gmx.net wrote:
Mike Christensen, 27.08.2010 11:39:
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement
That really helped me, thanks - although I wish someone had told me
about that/ before/ I tried to run a nuclear reactor using MSSQL
On 27/08/10 07:30, Mike Christensen wrote:
I found this tool pretty helpful for validating my architectural decisions..
Won't log state = all catch everything?
Richard
On 27/08/10 10:39, Mike Christensen wrote:
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit
Hi,
Apparently scalar subquery when used as a part of SELECT statement and when
it does not depend on outer query columns
is executed only once per statement, e.g.:
postgres=# select i, (select random()) rand from generate_series(1, 3) i;
i | rand
---+---
1 |
http://www.postgresql.org/docs/8.4/interactive/runtime-config-logging.html#GUC-LOG-STATEMENT
[...]
Valid values are none, ddl, mod, and all.
regards
andreas
On 08/27/2010 03:01 PM, Richard Harley wrote:
Won't log state = all catch everything?
Richard
On 27/08/10 10:39, Mike
Hello -
I'm relatively new to the postgresql world - primarily using it to load up a
backup of our hosted Jive community databases (which use postgresql).
To that end, we've created and scheduled a batch file (yes, we're using a
windows server...) to download the backups (*.dmp files) from the
Hi All
Any idea about this problem ??
Thanks..
Tamanna
-Original Message-
From: tamanna madaan
Sent: Fri 8/20/2010 11:54 AM
To: pgsql-general@postgresql.org
Subject: error while autovacuuming
Hi All
I am using a cluster setup with two nodes in it . postgres version is 8.1.2 and
Hi All,
I am looking for a way to define where index files should be located.
I am wanting to store the index files on a separate SSD from the database
itself. I can see that there is a way to define this from within the
database. Is there a way to do this at a system level within the
Alright, well, we'll probably do something with the archive command, then,
like either echoing %f to a log file or sending that to syslog (and then,
after the echo, doing the actual cp or scp or rsync or whatever). That way,
we should be able to get some form of timestamp of when each WAL file is
In response to Callum Scott :
Hi All,
I am looking for a way to define where index files should be located.
I am wanting to store the index files on a separate SSD from the database
itself. I can see that there is a way to define this from within the
database. Is there a way to do this
On Fri, Aug 27, 2010 at 3:21 PM, tamanna madaan
tamanna.ma...@globallogic.com wrote:
Hi All
Any idea about this problem ??
Thanks..
Tamanna
-Original Message-
From: tamanna madaan
Sent: Fri 8/20/2010 11:54 AM
To: pgsql-general@postgresql.org
Subject: error while
On 27 Aug 2010, at 12:43, Richard Harley wrote:
That really helped me, thanks - although I wish someone had told me about
that before I tried to run a nuclear reactor using MSSQL
Gosh, seems like someone picked up on my joke when the world will end - namely
at the release-date of
Excerpts from tamanna madaan's message of vie ago 27 05:51:16 -0400 2010:
I am using a cluster setup with two nodes in it . postgres version is 8.1.2
and slony 1.1.5 is being used for replication.
I have autovacuum enabled. But it was giving the following error while
vacuuming template0
are there any documents describe the index mechanic? For example, how to
store the B tree in tables in hard disk?
thanks!
peng
Early Bird Registration for Surge Scalability Conference 2010 ends next
Tuesday, August 31. We have a killer lineup of speakers and architects
from across the Internet. Listen to experts talk about the newest
methods and technologies for scaling your Web presence.
On 08/27/10 8:43 AM, A. Kretschmer wrote:
In response to Callum Scott :
Hi All,
I am looking for a way to define where index files should be located.
I am wanting to store the index files on a separate SSD from the database
itself. I can see that there is a way to define this from within
I am trying to calculate a value from a current record in a query and
can't seem to get it working.
Here is the shortened query;
SELECT
s.id,
r.the_date_time,
s.open_price,
s.high_price,
s.low_price,
s.close_price,
thesheet_onepair.symbol,
Hello
you used a wrong syntax
see
http://www.pgsql.cz/index.php/PL/pgSQL_%28en%29#Usage_PL.2FpgSQL_function_with_parametres_of_type_table
Regards
Pavel Stehule
2010/8/28 Jon Griffin j...@jongriffin.com:
I am trying to calculate a value from a current record in a query and can't
seem to
21 matches
Mail list logo