the user tries to do kill -9 -1 and log in
again
in the startup script i do the
following
/sbin/pidof -s postmaster
and it still displays some value,
however ps -aef | grep postmaster does not display
anything
is it ok if i do the following
pid1=`/sbin/pidof -s
postmaster` pid2=`ps -
I recently saw this in some postgres logs:
ERROR: could not access status of transaction ...
DETAIL: could not open file "pg_clog/...": No such file or directory
STATEMENT: COPY ...
The copy command was issued amongst a number of other queries from an
application layer at the same time as a
On Sun, Apr 16, 2006 at 04:32:25PM -0400, Tom Lane wrote:
> To analyze the plan used for a parameterized query, try
>
> PREPARE foo(...) AS SELECT ... $n ...
>
> EXPLAIN ANALYZE EXECUTE foo(...)
>
> But I already know what you're going to find: the planner's estimates
> for the rang
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Sun, Apr 16, 2006 at 07:07:11PM +0300, [EMAIL PROTECTED] wrote:
>> I am interested to know if I can define an unique index on a timestamp
>> column to reject values within one hour.
Perhaps
CREATE UNIQUE INDEX foo ON tab (date_trunc('hour', co
[EMAIL PROTECTED] writes:
> EXPLAIN ANALYZE doesn't show the slow timing
> because it requires values, not $n placeholders,
To analyze the plan used for a parameterized query, try
PREPARE foo(...) AS SELECT ... $n ...
EXPLAIN ANALYZE EXECUTE foo(...)
But I already know what you'
I have a benchmark test which runs a query very slowly under certain
circumstances. I used Ethereal to capture the packet traffic, and
also enabled debug5 logging out of curiousity. While the slow query
is in progress, there is no log or packet activity, but the cpu is
busy. These packets are be
On Sat, Apr 15, 2006 at 10:31:26AM -0400, Francisco Reyes wrote:
> [EMAIL PROTECTED] writes:
>
> >Usage is to match data from the key and val tables to fetch the data
> >value from the sid table.
>
> What is the relation between key and val tables?
> Will key.id and val.id be equal?
This benchma
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
>
> yes, this is a good example, but I do not want to use an exception block
> because of the warning present on documentation regarding exception blocks
No problem, i want to show a transaction-secure solution. You can use
this without the excepti
yes, this is a good example, but I do not want to use an exception block
because of the warning present on documentation regarding exception blocks
"*Tip: * A block containing an EXCEPTION clause is significantly more
expensive to enter and exit than a block without one. Therefore, don't
use E
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
>
> hello,
>
> I want to write a function to validate an inet data type, but I figure that
> postgres should already have such a function to use before inserting values
> in inet type columns.
> is it possible to access postgres's validation funct
On Sun, Apr 16, 2006 at 07:07:11PM +0300, [EMAIL PROTECTED] wrote:
> I am interested to know if I can define an unique index on a timestamp
> column to reject values within one hour.
Last month I posted an idea for enforcing unique constraints on
date ranges by using a composite type and a custom
hello,
I am interested to know if I can define an unique index on a timestamp
column to reject values within one hour.
insert into table(timestamp_col) values(LOCALTIMESTAMP);
insert into table(timestamp_col) values(LOCALTIMESTAMP + '5
minutes'::INTERVAL);
I want the second insert to fail w
hello,
I want to write a function to validate an inet data type, but I figure
that postgres should already have such a function to use before
inserting values in inet type columns.
is it possible to access postgres's validation function for inet types ?
I have snooped through the catalogs but
13 matches
Mail list logo
