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
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
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
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:
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
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 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
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
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
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
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
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
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
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
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
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
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
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 —
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
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
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 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
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 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
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 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
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: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
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
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 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
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 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
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
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
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
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
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
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
all
how to set up PGTAB file ? any example for
PGTAB=/opt/postgres/utilities/conf/pgtab
thanks
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
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
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
> 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
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
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
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
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
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
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
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
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
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,
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)
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
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 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
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
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
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:
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
> 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 |
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
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
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
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
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
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,
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
SemiconductorInspection=# \dt+
List of relations
Schema | Name | Type | Owner |Size| Description
+--+---+--++-
public | lot | table | postgres | 8192 bytes |
public | meas
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
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
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
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 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.
=
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:
76 matches
Mail list logo
