Tom Lane wrote:
Kim Bisgaard [EMAIL PROTECTED] writes:
The reason the first query is not performing is because the query
optimizer does not push the conditions down into the sub-queries - right??
Well, it's not the same condition: the WHERE clause is constraining
the output variable
Hello list,
I have PostgreSQL 8.0 on Windows Server 2000, and wrote a small .NET
program that creates a subprocess that executes psql with a sql script
as input (psql -U user -f script.sql).
This script runs well if I start psql from the command line and execute
it there. But within the
Hello!
I have a table eith name person as described below. It has an unique
index for id column (it is also primary key) and has an index for parent
column.
If I run a query with where clause on id column it uses the index (look
at the first explain analyze result; it says Index Scan
Joe wrote:
I see there's a pgsql-cygwin list and a pgsql-hackers-win32 list, but no
pgsql-win32 list. I browsed through the pgsql-novice and pgsql-general
archives and only saw a few Windows-related posts. Which of those two
lists is most appropriate for asking newbie-type questions about
Sezai YILMAZ wrote:
Hello!
I have a table eith name person as described below. It has an unique
index for id column (it is also primary key) and has an index for parent
column.
If I run a query with where clause on id column it uses the index (look
at the first explain analyze result; it
On Fri, Jun 24, 2005 at 11:44:50AM +0300, Sezai YILMAZ wrote:
Hello!
I have a table eith name person as described below. It has an unique
index for id column (it is also primary key) and has an index for parent
column.
snip
Why the difference of both queries is so dramatical for unique
Scott Goldstein wrote:
I had a couple of questions about Postgres 8.0 on Windows platforms:
1. Has Postgres 8.0 seen many field deployments yet? What have been
the results?
There seems to have been a good take-up. Some people will have been
deploying it even before the official release.
Richard Huxton wrote:
Sezai YILMAZ wrote:
Hello!
I have a table eith name person as described below. It has an unique
index for id column (it is also primary key) and has an index for
parent column.
If I run a query with where clause on id column it uses the index
(look at the first
Sezai YILMAZ wrote:
Richard Huxton wrote:
OK - all very simple. And you've said there are about 580,000 rows.
test= explain analyze select id,name from person where id in
('17201', '338191', '244319', '515209', '20415');
Why are you quoting integers?
I qouted them to use indexes. The
Currently my server has two raid controllers both with
5 disks attached::
On raid1: i have the database (RAID 1/0)
on raid2: i have the pg_xlog (RAID 0)
is this the optimal configuration or do i need to make
some changes for better performance
Regards
Himanshu
Scott Goldstein [EMAIL PROTECTED] writes:
I had a couple of questions about Postgres 8.0 on Windows platforms:
1. Has Postgres 8.0 seen many field deployments yet? What have been the
results?
I have 8.0.2 in production with zero problems. It's not a high-load
installation but it's been
Himanshu Baweja [EMAIL PROTECTED] writes:
Currently my server has two raid controllers both with
5 disks attached::
On raid1: i have the database (RAID 1/0)
on raid2: i have the pg_xlog (RAID 0)
is this the optimal configuration or do i need to make
some changes for better performance
On Tue, Jun 07, 2005 at 05:49:10PM +0200, Gorodowienko Daniel wrote:
I want to write a function that returns a raise message catched by:
EXCEPTION
WHEN RAISE_EXCEPTION THEN
RETURN .
If exception was raise like this:
RAISE EXCEPTION 'some exception';
and I want to get 'some
This may cause troubles to, because sorting is done using LC_COLLATE
value, whuch cannot be changed, and is set with initdb.
So please consider this limitation before doing any changes.
---(end of broadcast)---
TIP 7: don't forget to increase your
Yeah, thanks!
But I've already tried this approach, and it's not quite i need.
Because as i understand foreign keys are built on indexes, so i get
*index* and corresponding foreign key definition.
Well then i have to find out what filed this index belongs to
(assuming 1 field - 1 index)
Joe [EMAIL PROTECTED] writes:
I see there's a pgsql-cygwin list and a pgsql-hackers-win32 list, but
no pgsql-win32 list. I browsed through the pgsql-novice and
pgsql-general archives and only saw a few Windows-related posts.
Which of those two lists is most appropriate for asking newbie-type
Does anyone know if there is a compiled version of libpq.dll (ssl
enabled) that does not require
libintl-2.dll, libiconv-2.dll
Whoever compiled these dlls failed to include version information with
them, so it makes it a royal pain to deploy them, and it appears they
must be in the system
On Thu, Jun 23, 2005 at 10:11:15PM -0700, mrix wrote:
But I've already tried this approach, and it's not quite i need.
Because as i understand foreign keys are built on indexes, so i get
*index* and corresponding foreign key definition.
Well then i have to find out what filed this index
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
Regarding question 3,
Select one incorrect statement regarding the installation of
On Fri, Jun 24, 2005 at 11:23:54AM +0100, Richard Huxton wrote:
I qouted them to use indexes. The other method is type casting the
values to indexed column type. I prefer the quoting method.
Sorry - this is just plain wrong.
If you had an int8 column and a value such as 17, then PG looked
On Fri, 2005-06-24 at 01:57, Frank Rittinger wrote:
Hello list,
I have PostgreSQL 8.0 on Windows Server 2000, and wrote a small .NET
program that creates a subprocess that executes psql with a sql script
as input (psql -U user -f script.sql).
This script runs well if I start psql from
I'm using PostgreSQL 7.4.2, and I'm having a little issue with rules.
I created a rule to watch for any inserts to table XYZ, and registered
a listener. But as I simply do a select on the table, I receive several
notifications when nothing has been inserted into the table.
db=# create rule
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
Regarding question 3,
Select one incorrect statement regarding the
Am Freitag, 24. Juni 2005 17:06 schrieb Tatsuo Ishii:
Really? I vaguley recall that someone who came from US complained
about the sort order of en locale. I thought English speakers prefer C
locale.
I have never seen an English dictionary or other list that sorts A, ... Z,
a, ... z and
On Fri, 2005-06-24 at 10:05, Omachonu Ogali wrote:
I'm using PostgreSQL 7.4.2, and I'm having a little issue with rules.
I created a rule to watch for any inserts to table XYZ, and registered
a listener. But as I simply do a select on the table, I receive several
notifications when nothing
Jeff Gold [EMAIL PROTECTED] writes:
I presented the start and the end of what seemed to my uninformed eye to
be the relevant error messages, since posting all 46.7 megabytes seemed
impolite. :-) According to grep there are 122034 lines that include
the word index in any combination of
Tatsuo Ishii wrote:
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
Regarding question 3,
Select one incorrect statement regarding
Am Freitag, 24. Juni 2005 17:05 schrieb Omachonu Ogali:
I'm using PostgreSQL 7.4.2, and I'm having a little issue with rules.
I created a rule to watch for any inserts to table XYZ, and registered
a listener. But as I simply do a select on the table, I receive several
notifications when
Peter Eisentraut [EMAIL PROTECTED] writes:
Am Freitag, 24. Juni 2005 17:06 schrieb Tatsuo Ishii:
Really? I vaguley recall that someone who came from US complained
about the sort order of en locale. I thought English speakers prefer C
locale.
I have never seen an English dictionary or other
On Fri, 2005-06-24 at 10:42, Joshua D. Drake wrote:
Tatsuo Ishii wrote:
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
Regarding
On Thu, Jun 23, 2005 at 07:34:30PM +0200, Magnus Hagander wrote:
Has Kerb4 been marked as depricated in the docs at all? If
not it might be best to just do that and then yank it later.
Yes, since 7.4.
http://www.postgresql.org/docs/8.0/static/auth-methods.html#KERBEROS-AUT
H
On Fri, Jun 24, 2005 at 08:42:00AM -0700, Joshua D. Drake wrote:
Regarding question 3,
Select one incorrect statement regarding the installation of PostgreSQL.
2 2. At least 60MB of free disk space is required for compilation.
Number 2 is
also confusing because am I compiling ALL of
[Please copy the mailing list on replies.]
On Fri, Jun 24, 2005 at 05:52:46PM +0300, Marik wrote:
But what i really need is field this constraint belongs to then...
I'd like to have such result:
CREATE TABLE foo (id integer PRIMARY KEY);
CREATE TABLE bar (fooid integer NOT NULL REFERENCES
Does pg_ctl status return true even if the database is not ready yet to
receive requests? We are using pg_ctl status to tell us if the database
is up, but I'm wondering if it could return true, but a client could
connect and still get the FATAL: database is starting up error?
- DAP
David Parker
Jeff Gold [EMAIL PROTECTED] writes:
Hm. After discussing this with people here we have a hypothesis. The
process that issues the TRUNCATE command does something a little
peculiar: every minute or so twelve distinct functions are overwritten
using CREATE OR REPLACE FUNCTION. Perhaps this
Richard Huxton wrote:
You will have (assuming the same as on *nix):
1. Master process - starts all the others
2. One backend per client
3. Stats buffer/collector
4. Auto-vacuum (optional, not really part of the main system yet)
It appears that, when started as a Windows service, four
Tom Lane wrote:
Joe [EMAIL PROTECTED] writes:
I see there's a pgsql-cygwin list and a pgsql-hackers-win32 list, but
no pgsql-win32 list. I browsed through the pgsql-novice and
pgsql-general archives and only saw a few Windows-related posts.
Which of those two lists is most appropriate for
On Fri, Jun 24, 2005 at 04:00:36PM -0400, Joe wrote:
Richard Huxton wrote:
You will have (assuming the same as on *nix):
1. Master process - starts all the others
2. One backend per client
3. Stats buffer/collector
4. Auto-vacuum (optional, not really part of the main system yet)
Jeff Gold [EMAIL PROTECTED] writes:
I was sort of expecting you to come back and say that you
thought the process might have done 640K TRUNCATEs over its lifespan,
but I guess not?
That's possible. The process does twelve TRUNCATEs every minute. The
problem we're talking about seems to
I wrote:
I think we have a suspect --- will go look.
Jeff, are you doing CLUSTER operations too?
Some preliminary testing says that:
7.4:
CLUSTER leaks a pg_temp_nnn relcache entry per call; if table
has toast subtable it also leaks a pg_toast_nnn_index entry per call
TRUNCATE on a table
Tom Lane wrote:
I was sort of expecting you to come back and say that you
thought the process might have done 640K TRUNCATEs over its lifespan,
but I guess not?
That's possible. The process does twelve TRUNCATEs every minute. The
problem we're talking about seems to occur only when the
Tom Lane wrote:
I suppose what we are looking at here is some operation that is
invalidating a relcache entry but failing to clear it.
Hm. After discussing this with people here we have a hypothesis. The
process that issues the TRUNCATE command does something a little
peculiar: every
David Parker [EMAIL PROTECTED] writes:
Does pg_ctl status return true even if the database is not ready yet to
receive requests?
pg_ctl status just checks that the postmaster process is present.
(Until very recently, it wasn't even a bulletproof test for that...)
On Fri, Jun 24, 2005 at 08:42:00AM -0700, Joshua D. Drake wrote:
Regarding question 3,
Select one incorrect statement regarding the installation of PostgreSQL.
2 2. At least 60MB of free disk space is required for compilation.
Number 2 is
also confusing because am I
Peter Eisentraut [EMAIL PROTECTED] writes:
Am Freitag, 24. Juni 2005 17:06 schrieb Tatsuo Ishii:
Really? I vaguley recall that someone who came from US complained
about the sort order of en locale. I thought English speakers prefer C
locale.
I have never seen an English dictionary or
On Fri, Jun 24, 2005 at 08:42:00AM -0700, Joshua D. Drake wrote:
Tatsuo Ishii wrote:
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jim C. Nasby)
wrote:
On Fri, Jun 24, 2005 at 08:42:00AM -0700, Joshua D. Drake wrote:
Tatsuo Ishii wrote:
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
On Fri, 24 Jun 2005, Jim C. Nasby wrote:
On Fri, Jun 24, 2005 at 08:42:00AM -0700, Joshua D. Drake wrote:
Tatsuo Ishii wrote:
Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
I've made a PL/pgSQL function to validate UPC and EAN barcodes.
It works correctly, but is a little ugly.
Wondering if any PL/pgSQL experts can offer some suggestions. (I'm
new to PL/pgSQL.)
Main questions:
#1 - I wanted to add a 0 to the front of the barcode if it was only
12 characters long.
49 matches
Mail list logo