On Wed, 2009-04-22 at 13:31 -0400, Tom Lane wrote:
> "Maria L. Wilson" writes:
> > Question - is there any maintenance type item that we could to to check
> > for uncommitted transactions on a regular basis - outside of the
> > pg_prepared_xacts table?
>
> pg_prepared_xacts is the only SQL-le
Rafael Domiciano wrote:
> this table has about 15 indexes...
That would tend to make mass updates like this slow.
> How good are to Cluster table? Has any criteria to cluster table?
> How can I do it?
CLUSTER reads through the table in the sequence of an index, which you
specify, and crea
Hello,
Postgresql 8.3.2 on Windows server 2003 R2 standard
I have a client program connecting to postgresql
database.
The purpose is to find its session information in the
pg_stat_activity table.
But the PID value from the windows' task manager
doesn't equal to any value in the output of
s
Michael Monnerie wrote:
> Question: [CLUSTER] will not rewrite the indices for that table,
> right? Then a REINDEX could be interesting too.
CLUSTER always rebuilds all indexes on the table. There's no point
doing a REINDEX afterward or dropping indexes first.
-Kevin
--
Sent via pgsql-adm
On Freitag 24 April 2009 Scott Marlowe wrote:
> Also, if you're doing the select into thing, you can drop the indexes
> then recreate them. Usually also faster on a big table being
> reordered.
> CLUSTER always rebuilds all indexes on the table. There's no point
> doing a REINDEX afterward or dro
rafael.domici...@gmail.com (Rafael Domiciano) writes:
> Hello Kevin, Thnks for response,
> Doing the alter table to add the new column was fast: ALTER TABLE table1 ADD
> COLUMN new_column date;
> The problem is that I have to do a update in this column, and the values are
> going to be the a misc
Hi:
I can't delete a "parent" record from a table. The relation has "ON UPDATE
CASCADE ON DELETE CASCADE". As far as know, that causes that when you delete a
record from the parent table, the related one from the child table will be
deleted as well. However, I had to first delete the child reco
On Apr 24, 2009, at 10:00 AM, Félix Sánchez Rodríguez wrote:
Hi:
I can't delete a "parent" record from a table. The relation has "ON
UPDATE CASCADE ON DELETE CASCADE". As far as know, that causes that
when you delete a record from the parent table, the related one from
the child table wi
Hello everyone!
First of all: I'm using Postgres 8.2.4 on a WinXP machine.
I'm trying to create a function that creates a new user-role to allow
non-super-users to create users.
The function should look something like that (well, obviously it should
not...but it's to give you an idea, what I
Chris Browne wrote:
> I'd suggest adding an index
The OP said the table had 15 indexes already. I would guess one of
those could be used. Perhaps it has a primary key
> update table1 set new_column = [whatever calculation]
> where new_column is null and
> quasi_unique_colu
Hello again!
Problem solved!
I switched my language to plpgsql and used the execute-command. The
function now looks like:
CREATE OR REPLACE FUNCTION sys.create_user(character varying, character
varying)
RETURNS void AS
$BODY$
BEGIN
execute 'CREATE USER ' || quote_ident($1) || ' PASSWORD
i wonder if its threads rather than individual processes.
2009/4/24 chen shan
>
> Hello,
>
> Postgresql 8.3.2 on Windows server 2003 R2 standard
>
> I have a client program connecting to postgresql
> database.
>
> The purpose is to find its session information in the
> pg_stat_activity table.
>
Kevin Grittner wrote:
> Chris Browne wrote:
>
>> I'd suggest adding an index
>
> The OP said the table had 15 indexes already. I would guess one of
> those could be used. Perhaps it has a primary key
>
>> update table1 set new_column = [whatever calculation]
>> where new_column is
13 matches
Mail list logo
