2010/1/13 Vincenzo Romano :
> 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" ha scritto:
>
> Vincenzo Romano writes:
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
l
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 wrote:
> From: Grzegorz Jaśkiewicz
> Subject: Re: [GENERAL] Extremely Slow C
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, other
SemiconductorInspection=# \dt+
List of relations
Schema | Name | Type | Owner |Size| Description
+--+---+--++-
public | lot | table | postgres | 8192 bytes |
public | meas
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 o
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
> diac
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 al
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 lot_id
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
> 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 c
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
> Mihamina Rakotomandimby :
> 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 | joem|Joe M |
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:
http://www.postgresql.org/mailpref
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 get:
2010/1/13 Daniel Schuchardt :
> 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 pgsql-general m
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" ha scrit
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: temporary
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 im
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 :
> 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,
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
ne
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 were
Claudio Eichenberger 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
workers will be autovac
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...
http://b
2010/1/13 Vincenzo Romano :
> 2010/1/13 Adrian Klaver :
>> 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 aroun
2010/1/13 Vincenzo Romano :
> 2010/1/13 Vincenzo Romano :
>> 2010/1/13 Adrian Klaver :
>>> 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 th
On Wed, Jan 13, 2010 at 12:29 AM, ChronicDB 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: singh_gurjeet
Ma
> 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 a
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 what
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, so
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 writes:
> > The parameter autovacuum_naptime seems to take minutes for seconds.
>
> How many databas
all
how to set up PGTAB file ? any example for
PGTAB=/opt/postgres/utilities/conf/pgtab
thanks
2010/1/14 Filip Rembiałkowski :
> 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 integer, not an INT
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 comple
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 fu
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 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:
http://www.postgresql.org/mailpre
On 01/13/2010 09:37 AM, Vincenzo Romano wrote:
2010/1/13 Vincenzo Romano:
2010/1/13 Vincenzo Romano:
2010/1/13 Adrian Klaver:
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 thi
My issue involves the USING predicates, though.
Il giorno 13 gen, 2010 10:26 p., "Adrian Klaver"
ha scritto:
On 01/13/2010 09:37 AM, Vincenzo Romano wrote: > > 2010/1/13 Vincenzo
Romano
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,
t
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)
Il
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
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 pa
W dniu 13 stycznia 2010 19:52 użytkownik Andrej
napisał:
> 2010/1/14 Filip Rembiałkowski :
> > 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_fil
On Wed, Jan 13, 2010 at 11:31 AM, Amy Smith 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 de sistemas
G
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 everyth
On 01/13/2010 11:25 AM, Tom Lane wrote:
> akuster writes:
>> How can I receive vulnerability notifications?
>
> Read release announcements in pgsql-announce.
>
> regards, tom lane
Thanks,
- Armin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Nick 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 immutable.
http://www.
On Jan 13, 4:21 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Nick 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
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 wrote:
> From: Craig Ringer
> Subject: Re: [GENERAL] Extremely Slow Cascade Delete Operation
> To: "
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 na
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
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 —
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
> lit
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 d
Craig Ringer 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?
There's plenty of
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 wrote:
> As in previous years, we're looking at organising a dinner prior to
> the FOSDEM conference in
In response to Jaime Casanova :
> On Wed, Jan 13, 2010 at 11:31 AM, Amy Smith 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
--
And
Tom Lane wrote:
> Craig Ringer 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
2010/1/14 Adrian Klaver :
> 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
On Wed, Jan 13, 2010 at 11:15 PM, Craig Ringer
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
> the rest of us need not ca
Craig Ringer 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
> with an app. It'd
Scott Marlowe wrote:
> On Wed, Jan 13, 2010 at 11:15 PM, Craig Ringer
> 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
On Thu, Jan 14, 2010 at 7:19 AM, Vincenzo Romano <
vincenzo.rom...@notorand.it> wrote:
> 2010/1/14 Adrian Klaver :
> > 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 t
Scott Mead 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
http://archives.postgresql.org/pgsql-committers/2009-11/msg00094.php
but as you note it was
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 11:
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 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: http://www.enterprisedb.com
Yes, I'm in South Africa, which might make it problematic!
2010/1/14 Dave Page :
> On Thu, Jan 14, 2010 at 1:14 PM, Dave Coventry 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
> leas
76 matches
Mail list logo