On Sun, Mar 13, 2011 at 11:59 PM, Gnanakumar wrote:
[...]
Although it's unrelated to your query about an exception being raised,
a word of advice on temporary tables. (This may not be relevant to
your situation, but it's no small source of pain in one of the systems
I'm responsible for.) Signi
> Although it's unrelated to your query about an exception being raised,
> a word of advice on temporary tables. (This may not be relevant to
> your situation, but it's no small source of pain in one of the systems
> I'm responsible for.) Significant use of temporary tables will cause
> commensur
Hi,
We're using PostgreSQL v8.2.3. Ours is a web-based application, language is
Java and we're using pgpool-II v 2.0.1 purely for connection pooling (we
don't use other features of pgpool like Replication, Load Balancing, etc.).
We're creating temporary table using "CREATE TEMP TABLE FOO(col1, c
Hello,
Is there a way of disabling/dropping all constrainsts in a given
database? I need to restore a db which has duplicate values in nearly
half of its tables then remove duplicates and then add the constraints
back. Is there a way to do that for each table in one
statement/function? It may be e
Lukasz Brodziak, 14.03.2011 10:26:
Hello,
Is there a way of disabling/dropping all constrainsts in a given
database? I need to restore a db which has duplicate values in nearly
half of its tables then remove duplicates and then add the constraints
back. Is there a way to do that for each table i
> From: Lukasz Brodziak
> Subject: [ADMIN] Dropping all constraints in database
> To: pgsql-admin@postgresql.org
> Date: Monday, 14 March, 2011, 9:26
> Hello,
>
> Is there a way of disabling/dropping all constrainsts in a
> given
> database? I need to restore a db which has duplicate values
> in
"Gnanakumar" wrote:
> Instead of touching/refactoring all the 35 functions just to
> rename the table name, we decided to create the temporary table
> name same as that of existing permanent table for running this
> complex report alone
If it were me I would be running some global search and r
[getting back to the original question]
"Gnanakumar" wrote:
> in order to monitor the growth (table size) of temporary tables
> created while report is running, we've a "separate Java standalone
> program" which automatically executes the following query every 5
> minutes and keeps writing out
(Apologies for thread-jacking; I saw something similar in the OP's
description of his setup that I thought warranted a word of advice.)
On Mon, Mar 14, 2011 at 1:50 AM, Gnanakumar wrote:
> Do you think that this "significantly bloated system catalogs" is caused
> because of the old version 8.2.3
Kevin,
What did you mean by "OP"?
Did you look at veil?
http://veil.projects.postgresql.org/curdocs/index.html
(This was mentioned earlier, but the OP didn't respond to that.)
Thanks,
Sara
--- On Thu, 3/10/11, Kevin Grittner wrote:
From: Kevin Grittner
Subject: Re: [ADMIN] Oracle
On Mon, 2011-03-14 at 20:04 -0700, H S wrote:
> Kevin,
>
> What did you mean by "OP"?
It means "Original Poster"
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.
Dear Sirs,
After this command , what I should do?
Can not use createdb test command and psql test.
I installed correctly postgres by source code.
[postgres@localhost bin]$ ./postgres -D /usr/local/pgsql/data
LOG: database system was shut down at 2011-03-15 07:56:00 EDT
LOG: autovacuum la
> The key to understanding the problem is to realize that system
> catalogs are pretty much regular tables in PostgreSQL, with some
> additional special rules (no triggers, can't be CLUSTERed or ALTERed,
> &c). Anything you'd do in a regular table that would create a dead
> tuple UPDATEs, DELETE
Try following command
createdb -h -p -U [DBNAME]
psql -d [DBNAME] -U
Date: Mon, 14 Mar 2011 21:39:17 -0700
From: aras_h1...@yahoo.com
Subject: [ADMIN] createdb does not work?!
To: pgsql-admin@postgresql.org
Dear Sirs,
After this command , what I should do?
Can not use createdb te
--- On Tue, 3/15/11, H S wrote:
From: H S
Subject: Re: [ADMIN] createdb does not work?!
To: "dhaval jaiswal"
Date: Tuesday, March 15, 2011, 9:31 AM
in one terminal I have recieved this notes:
LOG: database system was shut down at 2011-03-15 07:56:00 EDT
LOG: autovacuum launcher started
LO
15 matches
Mail list logo