2010/1/13 Vincenzo Romano vincenzo.rom...@notorand.it:
The static binding worked fine in the second EXECUTE USING statement but not
in the first one.
I still think that it's weird more than wishful.
I can work it around, though.
Il giorno 12 gen, 2010 4:13 p., Tom Lane t...@sss.pgh.pa.us ha
I have 3 tables - lot, unit and measurement
1 lot is having relationship to many unit.
1 unit is having relationship to many measurement.
delete cascade is being used among their relationship
I try to perform delete operation on single row of lot.
try checking if it is waiting perhaps for something (is locked).
Peek at: (using different connection)
SELECT * FROM pg_stat_activity;
SELECT * FROM pg_locks;
Did you used prepared transactions ?
Try:
SELECT * FROM pg_prepared_xacts ;
Maybe some other transaction is blocking it.
HTH
--
Sent
I realize the READ performance goes down dramatically when my table goes large.
Every new day goes on, my table can increase x millions of new rows.
I was wondering whether this is good practice I can design my database in this
way?
Instead of having
lot - unit - measurement
Can I have
It looks like this :
http://sites.google.com/site/yanchengcheok/Home/log.txt
I put it in google site, for easy reading)
Any hint? Thanks!
Thanks and Regards
Yan Cheng CHEOK
--- On Wed, 1/13/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote:
From: Grzegorz Jaśkiewicz gryz...@gmail.com
It doesn't look like it is locked, so it is carrying the delete out.
However that doesn't mean, that there isn't any other locking
occurring, or simply your disks are rather busy.
Also, maybe the DB is rather big, what are the table sizes ?
If you are using 8.4+, than do \dt+ to get an idea,
SemiconductorInspection=# \dt+
List of relations
Schema | Name | Type | Owner |Size| Description
+--+---+--++-
public | lot | table | postgres | 8192 bytes |
public |
Hi,
Am 13.01.2010 09:16, schrieb Yan Cheng Cheok:
I realize the READ performance goes down dramatically when my table goes large.
Every new day goes on, my table can increase x millions of new rows.
I was wondering whether this is good practice I can design my database in this
way?
Instead
Am 12.01.2010 um 12:36 schrieb Martin Flahault:
We have spend some time evaluating PostgreSQL and we can't get correct
outputs with the ORDER BY command.
LC_COLLATE and LC_CTYPE are set to fr_FR.UTF-8.
It seems there is a known problem with the collating order of text including
Hi,
on one of our Mac servers an update (Remote Desktop Client) killed yesterday
the postmaster process. Apparently this did not have any influence on existing
connections and therefore was not detected until some time later, when no
connection for a backup could be made.
I have then closed
On 13/01/2010 4:09 PM, Yan Cheng Cheok wrote:
I have 3 tables - lot, unit and measurement
1 lot is having relationship to many unit.
1 unit is having relationship to many measurement.
delete cascade is being used among their relationship
SemiconductorInspection=# delete from lot where
On 12/01/2010 7:36 PM, Martin Flahault wrote:
Hi,
We are a software publisher searching for a new DBMS for our software.
We have more than one hundred installed servers, running Mac OS and a
Primebase database.
We have spend some time evaluating PostgreSQL and we can't get correct
outputs with
2010/1/13 Ralf Schuchardt r...@gmx.de
Hi,
on one of our Mac servers an update (Remote Desktop Client) killed
yesterday the postmaster process. Apparently this did not have any influence
on existing connections and therefore was not detected until some time
later, when no connection for a
Manao ahoana, Hello, Bonjour,
I have LDAP entries, and SQL tables are the relation between them.
There are only relations between 2 entries.
There are modem and customers entries in the LDAP directory
I need advice on optimizing the way I store relations.
For example (This is on MySQL, just for
Mihamina Rakotomandimby miham...@gulfsat.mg :
Have you another way to do it?
- splitting the comma separated fields?
I mean:
customer_cn|customer_sn| customer_uid|modem_cn|modem_sn|modem_uid|
staff | (null) |(null) |staff | (null)| (null) |
Joe M |Mudd |
Hy,
can anybody give us a hint if we can use that combination?
Thanks,
Daniel.
--
Daniel Schuchardt
/Softwareentwicklung/
/http://www.prodat-sql.de/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hello,
Concerns: 8.4.2
I cannot test it on other systems than FreeBSD so I don't know whether it's
just FreeBSD related.
The parameter autovacuum_naptime seems to take minutes for seconds.
On a completely idle system, no db access, with the default
autovacuum_naptime=1min configuration I
2010/1/13 Daniel Schuchardt d.schucha...@prodat-sql.de:
Hy,
can anybody give us a hint if we can use that combination?
first 64bit PostgreSQL on win will be 8.5
regards
Pavel
Thanks,
Daniel.
--
Daniel Schuchardt
/Softwareentwicklung/
/http://www.prodat-sql.de/
--
Sent via
and besides, I think 8.1 is not supported on win32 anymore.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tuesday 12 January 2010 9:38:06 pm Vincenzo Romano wrote:
The static binding worked fine in the second EXECUTE USING statement but
not in the first one.
I still think that it's weird more than wishful.
I can work it around, though.
Il giorno 12 gen, 2010 4:13 p., Tom Lane
I would like to log usage of temporary files for sort/join operations, but
only when size of these files exceeds some threshold.
So I set in postgresql.conf (this is 8.4.2)
log_temp_files = 4MB
But then I got these messages in log file
2010-01-12 13:24:49 CET 24899 fi...@la_filip LOG:
On 13/01/2010 6:15 PM, Daniel Schuchardt wrote:
Hy,
can anybody give us a hint if we can use that combination?
You can use libpq on 64-bit windows to talk to an 8.1 database if you
really must.
I really wouldn't recommend running the 8.1 database on windows. Win32
releases of Pg see big
8.1 version doesn't make any sense anyway, on any platform. There's
been so many improvements since, and if one wants to be conservative -
go for 8.3, which has tons of improvements over 8.1, especially in
area of performance.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
2010/1/13 Adrian Klaver adrian.kla...@gmail.com:
On Tuesday 12 January 2010 9:38:06 pm Vincenzo Romano wrote:
The static binding worked fine in the second EXECUTE USING statement but
not in the first one.
I still think that it's weird more than wishful.
I can work it around, though.
Il
Am 13.01.2010 16:00, schrieb Craig Ringer:
On 13/01/2010 6:15 PM, Daniel Schuchardt wrote:
Hy,
can anybody give us a hint if we can use that combination?
You can use libpq on 64-bit windows to talk to an 8.1 database if you
really must.
I really wouldn't recommend running the 8.1 database
Here is an exemple :
postgres=# create database newbase;
CREATE DATABASE
postgres=# \c newbase;
psql (8.4.2)
You are now connected to database newbase.
newbase=# create table t1 (contenu text);
CREATE TABLE
newbase=# insert into t1 values ('a'), ('e'), ('à'), ('é'), ('A'), ('E');
INSERT 0 6
Daniel Schuchardt wrote:
can anybody give us a hint if we can use that combination?
PostgreSQL 8.1 for Windows became unsupported over two years ago due to
technical issues: http://www.postgresql.org/about/news.865
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy
There
Claudio Eichenberger c...@yourshop.com writes:
The parameter autovacuum_naptime seems to take minutes for seconds.
How many databases in your installation?
autovacuum_naptime is the target cycle time for any one database.
If you have N databases then the time between launching autovacuum
In response to Daniel Schuchardt :
we plan to upgrade to 8.4 the next time but currently everything is build with
8.1. thanks for your awnsers, so we wont try it.
but i think we will wait till 8.5 because of the 64 bit problem.
I'm not expect that 8.5 contains 64 bit for windows...
2010/1/13 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/1/13 Adrian Klaver adrian.kla...@gmail.com:
On Tuesday 12 January 2010 9:38:06 pm Vincenzo Romano wrote:
The static binding worked fine in the second EXECUTE USING statement but
not in the first one.
I still think that it's weird
2010/1/13 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/1/13 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/1/13 Adrian Klaver adrian.kla...@gmail.com:
On Tuesday 12 January 2010 9:38:06 pm Vincenzo Romano wrote:
The static binding worked fine in the second EXECUTE USING statement but
On Wed, Jan 13, 2010 at 12:29 AM, ChronicDB i...@chronicdb.com wrote:
[3] http://chronicdb.com/chronicdb_early_adoption_program
Page not found
--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.enterprisedb.com
singh.gurj...@{ gmail | yahoo }.com
Twitter/Skype:
we plan to upgrade to 8.4 the next time but currently everything is
build with 8.1. thanks for your awnsers, so we wont try it.
but i think we will wait till 8.5 because of the 64 bit problem.
we did not upgrade because 81 has autocast and later version doesn't,
so we need to check all
Hi,i have a PL/PERL RETURN SETOF function which processes a few 10k records.The
processing takes quite some time and in order to display progressI use a
return_next after every few thousand records.
However, the function returns all messages when it completes and exists which
is not really
Ok, thats fine for us.
Most of our customers run Debian in 64Bit mode with Postgres 81 64 Bit,
but some won't use a *nix.
Thanks.
Am 13.01.2010 18:49, schrieb Joshua D. Drake:
we plan to upgrade to 8.4 the next time but currently everything is
build with 8.1. thanks for your awnsers,
Tom
Hello,
55 databases which made me believe minutes correspond to seconds!
Many thanks for your explanation
Regards
Claudio
On 2010-01-13 11:08:35, Tom Lane wrote:
Claudio Eichenberger c...@yourshop.com writes:
The parameter autovacuum_naptime seems to take minutes for seconds.
How
all
how to set up PGTAB file ? any example for
PGTAB=/opt/postgres/utilities/conf/pgtab
thanks
2010/1/14 Filip Rembiałkowski plk.zu...@gmail.com:
I would like to log usage of temporary files for sort/join operations, but
only when size of these files exceeds some threshold.
So I set in postgresql.conf (this is 8.4.2)
log_temp_files = 4MB
Just a wild guess... the DOCU says it's an
January 13, 2010
PostgreSQL Conference East, The PostgreSQL Conference for Decision
Makers, End Users and Developers, is being held at the Radisson Plaza,
Warwick Hotel in Philadelphia on March 25th through 28th.
This is the second call for papers for this conference. You can review
the skeletal
On 1/13/2010 12:20 PM, Alex - wrote:
Hi,
i have a PL/PERL RETURN SETOF function which processes a few 10k records.
The processing takes quite some time and in order to display progress
I use a return_next after every few thousand records.
However, the function returns all messages when it
On 1/13/2010 1:26 PM, Andy Colson wrote:
On 1/13/2010 12:20 PM, Alex - wrote:
Hi,
i have a PL/PERL RETURN SETOF function which processes a few 10k records.
The processing takes quite some time and in order to display progress
I use a return_next after every few thousand records.
However, the
Morning,
How can I receive vulnerability notifications?
Regards,
Armin Kuster
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
akuster akus...@mvista.com writes:
How can I receive vulnerability notifications?
Read release announcements in pgsql-announce.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 01/13/2010 09:37 AM, Vincenzo Romano wrote:
2010/1/13 Vincenzo Romanovincenzo.rom...@notorand.it:
2010/1/13 Vincenzo Romanovincenzo.rom...@notorand.it:
2010/1/13 Adrian Klaveradrian.kla...@gmail.com:
On Tuesday 12 January 2010 9:38:06 pm Vincenzo Romano wrote:
The static binding worked
My issue involves the USING predicates, though.
Il giorno 13 gen, 2010 10:26 p., Adrian Klaver adrian.kla...@gmail.com
ha scritto:
On 01/13/2010 09:37 AM, Vincenzo Romano wrote: 2010/1/13 Vincenzo
Romanovincenzo.rom...@notoran...
CREATE OR REPLACE FUNCTION public.alter_test(tbl text)
RETURNS
On 01/13/2010 01:39 PM, Vincenzo Romano wrote:
My issue involves the USING predicates, though.
WARNING:Old joke
Doctor: What is wrong?
Patient: My elbow hurts when I do this, what should I do?
Doctor: Quit doing that.
USING is not working the way you want, mainly for the reason you found,
It is not the check or the select.
It is the way the substitution has been implemented. It looks like the code
replaces the variable name and not the value.
Which is different from what is written at page 800.
I only hope they won't change the manual to match the feature/bug (warning:
new joke)
On Wed, Jan 13, 2010 at 04:15:06PM +0100, Martin Flahault wrote:
[postgres]
newbase=# select * from t1 order by contenu;
contenu
-
A
E
a
e
Postgresql outputs whatever the C library does on the underlying
system. The quality of this varies wildly.
à
As with others DBMS
On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
It is not the check or the select.
It is the way the substitution has been implemented. It looks like the code
replaces the variable name and not the value.
Which is different from what is written at page
W dniu 13 stycznia 2010 19:52 użytkownik Andrej
andrej.gro...@gmail.comnapisał:
2010/1/14 Filip Rembiałkowski plk.zu...@gmail.com:
I would like to log usage of temporary files for sort/join operations,
but
only when size of these files exceeds some threshold.
So I set in postgresql.conf
On Wed, Jan 13, 2010 at 11:31 AM, Amy Smith vah...@gmail.com wrote:
all
how to set up PGTAB file ? any example for
PGTAB=/opt/postgres/utilities/conf/pgtab
what is pgtab for? and where do you get it?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo
SELECT * FROM locations WHERE id = 12345 LIMIT 1
uses the primary key (id) index, but...
SELECT * FROM locations WHERE id = get_location_id_from_ip(641923892)
LIMIT 1
does not and is verrry slow. Any ideas why? Whats weird is that it
works (uses index) on a previous db, but when I copied
On 01/13/2010 11:25 AM, Tom Lane wrote:
akuster akus...@mvista.com writes:
How can I receive vulnerability notifications?
Read release announcements in pgsql-announce.
regards, tom lane
Thanks,
- Armin
--
Sent via pgsql-general mailing list
Nick nboutel...@gmail.com writes:
SELECT * FROM locations WHERE id = 12345 LIMIT 1
uses the primary key (id) index, but...
SELECT * FROM locations WHERE id = get_location_id_from_ip(641923892)
LIMIT 1
does not and is verrry slow. Any ideas why?
You didn't mark the function stable or
On Jan 13, 4:21 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
Nick nboutel...@gmail.com writes:
SELECT * FROM locations WHERE id = 12345 LIMIT 1
uses the primary key (id) index, but...
SELECT * FROM locations WHERE id = get_location_id_from_ip(641923892)
LIMIT 1
does not and is verrry slow.
OMG, I never know what is index (Sorry for my newbies) I will study about them
and update you all about their performance.
Thanks and Regards
Yan Cheng CHEOK
--- On Wed, 1/13/10, Craig Ringer cr...@postnewspapers.com.au wrote:
From: Craig Ringer cr...@postnewspapers.com.au
Subject: Re:
On Wednesday 13 January 2010 2:17:51 pm Scott Mead wrote:
On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
It is not the check or the select.
It is the way the substitution has been implemented. It looks like the
code replaces the variable name and not
On 13/01/2010 11:15 PM, Martin Flahault wrote:
It seems there is a problem with the collating order on BSD systems with
diacritics using UTF8.
If you put this text :
a
A
à
é
e
E
in a UTF8 text file and use the sort command on it, you will have the
same wrong output as with PostgreSQL :
A
E
a
e
Ivan Voras wrote:
Leigh Dyer wrote:
Hi,
For years now I've simply backed up my databases by doing a nightly
pg_dump, but since we added the ability for users to import binary
files
in to our application, which are stored in a bytea fields, the dump
sizes have gone through the roof — even with
I try to add index to tables.
(please refer to http://sites.google.com/site/yanchengcheok/Home/question.txt)
Database is designed in the following graphical view
(please refer to http://sites.google.com/site/yanchengcheok/Home/question.png)
Here is the setting of my database. All using default
Martijn van Oosterhout wrote:
in a UTF8 text file and use the sort command on it, you will have the same
wrong output as with PostgreSQL :
Yes, that's the basic idea. Mac OS X apparently provides ICU underneath
for programs that would like true unicode collation, but there is
little
Yan Cheng Cheok wrote:
I simply run a delete operation :
delete from lot where lot_id = 3;
It takes TWO hours and never able to return!
What does:
EXPLAIN DELETE FROM lot WHERE lot_id = 3;
report?
By the way, you've created a LOT of indexes. Indexes speed up lookups,
but can slow down
Craig Ringer cr...@postnewspapers.com.au writes:
Martijn van Oosterhout wrote:
Yes, that's the basic idea. Mac OS X apparently provides ICU underneath
for programs that would like true unicode collation, but there is
little chance that postgresql will ever use this.
Out of interest: Why not?
Anyone else want to join us for dinner? Please shout even if you
haven't firmed up your travel plans yet, so I have a rough idea of
numbers.
Thanks.
On Fri, Dec 11, 2009 at 6:59 PM, Dave Page dp...@pgadmin.org wrote:
As in previous years, we're looking at organising a dinner prior to
the
In response to Jaime Casanova :
On Wed, Jan 13, 2010 at 11:31 AM, Amy Smith vah...@gmail.com wrote:
all
how to set up PGTAB file ? any example for
PGTAB=/opt/postgres/utilities/conf/pgtab
what is pgtab for? and where do you get it?
See:
http://postgresqldba.org/pgdatabase
Andreas
Tom Lane wrote:
Craig Ringer cr...@postnewspapers.com.au writes:
Martijn van Oosterhout wrote:
Yes, that's the basic idea. Mac OS X apparently provides ICU underneath
for programs that would like true unicode collation, but there is
little chance that postgresql will ever use this.
Out of
2010/1/14 Adrian Klaver adrian.kla...@gmail.com:
On Wednesday 13 January 2010 2:17:51 pm Scott Mead wrote:
On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
It is not the check or the select.
It is the way the substitution has been implemented. It looks
On Wed, Jan 13, 2010 at 11:15 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
Perhaps someone who wants to use Mac OS X and Pg for their product will
come forward with some compat wrapper functions for the localizable
libc/posix functions, so Pg can just be built against the wrapper and
Craig Ringer cr...@postnewspapers.com.au writes:
Tom Lane wrote:
The state of OS X's POSIX-spec locale support is pretty pitiful, but on
the whole I'd say if you need better UTF8 locale support you could use
another OS.
Alas, people will want to run Pg on it anyway, especially when bundling
Scott Marlowe wrote:
On Wed, Jan 13, 2010 at 11:15 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
Perhaps someone who wants to use Mac OS X and Pg for their product will
come forward with some compat wrapper functions for the localizable
libc/posix functions, so Pg can just be built
On Thu, Jan 14, 2010 at 7:19 AM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
2010/1/14 Adrian Klaver adrian.kla...@gmail.com:
On Wednesday 13 January 2010 2:17:51 pm Scott Mead wrote:
On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
It is
Scott Mead scott.li...@enterprisedb.com writes:
Well it is in 8.5 Devel, so it could have been added immediately after
your thread started yesterday, I'm honestly not sure.
The particular paragraph mentioned was committed here
Just to clarify - this dinner is *not* the FOSDEM beer event, but an
Open Source database geeks get-together. It is on the same night as
the beer event though and will be very close assuming we get the
restaurant we want, so we can join the FOSDEM party after eating :-)
On Thu, Jan 14, 2010 at
Sounds great fun!
However, I presume I'm on the wrong Continent! ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jan 14, 2010 at 1:14 PM, Dave Coventry dgcoven...@gmail.com wrote:
Sounds great fun!
However, I presume I'm on the wrong Continent! ;)
I have no idea. I'm on the wrong landmass though, so there will be at
least one person arriving by air :-)
--
Dave Page
EnterpriseDB UK:
Yes, I'm in South Africa, which might make it problematic!
2010/1/14 Dave Page dp...@pgadmin.org:
On Thu, Jan 14, 2010 at 1:14 PM, Dave Coventry dgcoven...@gmail.com wrote:
Sounds great fun!
However, I presume I'm on the wrong Continent! ;)
I have no idea. I'm on the wrong landmass though,
76 matches
Mail list logo