-Original Message-
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Friday, April 30, 2010 12:01 PM
To: Arya, Ashish
Cc: pgsql-general@postgresql.org; Bhattacharya, A
Subject: Re: FW: [GENERAL] Java Memory Issue while Loading Postgres
library
Hi
Did you eventually figure o
On Thu, Apr 29, 2010 at 8:03 PM, Tom Lane wrote:
> Jorge Arevalo writes:
>> Many thanks! That was one of my errors. Another one was this:
>
>> char szDataPointer[10];
>> sprintf(szDataPointer, "%p", a_pointer);
>
>> These lines caused a memory error.
>
> That looks all right in itself (unless you
On Thu, Apr 29, 2010 at 8:08 PM, Martin Gainty wrote:
> it has been years since i've mucked in the C++ swamp but
> that means your (near) heap is ok but you're stack is hosed..
>
> probably specific to compiler (version) and Operating System(version) and
> environment settings..ping back if you ar
Hi
The hyphen which written in 'Olympus E-PL1' is different from
the one which written in 'Camera - Black'.
em-dash
http://www.fileformat.info/info/unicode/char/2014/index.htm
en-dash
http://www.fileformat.info/info/unicode/char/2013/index.htm
figure-dash
http://www.fileformat.info/info/unicode/
Hi chaps,
I've just upgraded a server from 8.3 to 8.4, and when trying to use the
parallel restore options I get the following error:
"pg_restore: [custom archiver] dumping a specific TOC data block out of order
is not supported without ID on this input stream (fseek required)"
The dump I'm tr
On 29 Apr 2010, at 19:21, Oliver Kohll - Mailing Lists wrote:
> The two plans (note I've been rewriting the field names for readability until
> now but haven't here):
>
> explain analyze SELECT year, sum(c) over (order by year)
> FROM (
> SELECT extract(year f
a.bhattacha...@sungard.com wrote:
We have a java exe making a call to a postgres function. This postgres
function internally makes a call to a dll (which is written using
Postgres extended C).
Now the issue is that, when we make a call to this dll, it consumes a
lot of memory and this memory
I want a column in my Users table that will keep track of which types of
notifications the user wants to subscribe to. There's probably about 10
different types, so I don't want to have 10 boolean columns because this
seems kinda hacky and makes adding new types more work. So I'm thinking
about u
En función de las propias sugerencias realizadas por los interesados en el
tema, ya está actualizado y disponible para todos los usuarios en la
información relacionada con el PGday Latinoamericano 2011 la oferta de la
cadena de turismo Cubanacan , para dar cobertura a todos los colegas que desd
Greg Smith wrote:
> Piotr Kublicki wrote:
> > We're thinking about installing Postgres on a virtual machine (RedHat 5
> > 64-bits), however not sure how many CPUs can be wisely assigned, without
> > wasting of resources.
>
> The database will use as many cores as you have available, so long as
>
On Fri, Apr 30, 2010 at 08:44:26AM +0200, Vincenzo Romano wrote:
> >>> Should I move to an "enterprise grade" version of PostgreSQL?
> >>
> >> The enterprise grade version of PostgreSQL is the community
> >> version.
> >>
> >> Proprietary forks exist, but they don't fix this kind of problem.
> >> :
Hi. I am running into a problem when trying to run pgTAP tests. Basically,
there are two functions with the same name in different schemas, and I'm trying
to get different versions at different times by modifying the search_path.
However, there seems to be a case where postgres is caching the
2010/4/30 Ing. Yunior Mesa Reyes :
> En función de las propias sugerencias realizadas por los interesados en el
> tema, ya está actualizado y disponible para todos los usuarios en la
> información relacionada con el PGday Latinoamericano 2011 la oferta de la
> cadena de turismo Cubanacan, para dar
Hi List !
I'm running "PostgreSQL 8.3.10 on i486-pc-linux-gnu, compiled by GCC
gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3" (Ubuntu 9.04)
I want to use -infinity,infinity as my date interval maximum endpoints in an
application I'm writing .
Is it possible to use date ?
I did a test but it looks li
Glyn Astill writes:
> I've just upgraded a server from 8.3 to 8.4, and when trying to use the
> parallel restore options I get the following error:
> "pg_restore: [custom archiver] dumping a specific TOC data block out of order
> is not supported without ID on this input stream (fseek required)
Dan S writes:
> I did a test but it looks like date doesn't support infinity as a value.
Try 8.4 or later.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pg
Mike Christensen writes:
> When a certain event happens, let's say event 4, I need to query for which
> users to notify. So I'll be doing something like:
> SELECT UserId FROM Users WHERE Subscriptions & 8;
> My question is say there's a million rows in the Users table. If I have an
> index on
On Fri, Apr 30, 2010 at 10:08 AM, Tom Lane wrote:
> Mike Christensen writes:
>> When a certain event happens, let's say event 4, I need to query for which
>> users to notify. So I'll be doing something like:
>
>> SELECT UserId FROM Users WHERE Subscriptions & 8;
>
>> My question is say there's a
Hi All -
Is there a way to find which functions are being used by table.
Ex :- If there are functions fnc_a, fnc_b, fnc_c and table A is used in
fnc_a and fnc_c, How can we find that ? can you please help?
regards
I was thinking thinking about the issue asked here, about an error in
a query causing the whole transaction to abort,
http://stackoverflow.com/questions/2741919/can-i-ask-postgresql-to-ignore-errors-within-a-transaction/2745677
which has already bothered so many postgresql users and has been
discus
Vincenzo Romano wrote:
> In this specific case, if you think about "inheritance for
> partitioning" and you stick with the example idea of "one partition
> per month", then the current solution is more than OK.
> In the real world, that is not really the general case, especially in
> the "enterpri
(anonymous) wrote:
> Is there a way to find which functions are being used by table.
> Ex :- If there are functions fnc_a, fnc_b, fnc_c and table A is used in
> fnc_a and fnc_c, How can we find that ? can you please help?
Basically, you can't. Functions are more or less black boxes
to Postgre
got it.. Thank you
On Fri, Apr 30, 2010 at 12:17 PM, Tim Landscheidt
wrote:
> (anonymous) wrote:
>
> > Is there a way to find which functions are being used by table.
> > Ex :- If there are functions fnc_a, fnc_b, fnc_c and table A is used
> in
> > fnc_a and fnc_c, How can we find that ? ca
Peter Hunsberger writes:
> If all subscriptions are roughly equal in popularity then any single
> select should give ~ 10% of the data. That would seem to be selective
> enough that you'd really want an index?
My personal rule of thumb is that 10% is around the threshold where
indexes stop being
why specific_name column on that view contains also OID ?
This makes two databases that are identical, have different values
there. Is there any specific reason for that ?
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
Tim Landscheidt writes:
> (anonymous) wrote:
>> Is there a way to find which functions are being used by table.
>> Ex :- If there are functions fnc_a, fnc_b, fnc_c and table A is used in
>> fnc_a and fnc_c, How can we find that ? can you please help?
> Basically, you can't. Functions are more
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I was thinking thinking about the issue asked here, about an error in
> a query causing the whole transaction to abort,
...
> I wonder if the suggestion I ("leonbloy") gave, of adding a SAVEPOINT
> after each insert (when doing interactive wo
--- On Fri, 30/4/10, Tom Lane wrote:
> Glyn Astill
> writes:
> > I've just upgraded a server from 8.3 to 8.4, and when
> trying to use the parallel restore options I get the
> following error:
>
> > "pg_restore: [custom archiver] dumping a specific TOC
> data block out of order is not support
2010/4/30 Alvaro Herrera :
> Vincenzo Romano wrote:
>
>> In this specific case, if you think about "inheritance for
>> partitioning" and you stick with the example idea of "one partition
>> per month", then the current solution is more than OK.
>> In the real world, that is not really the general c
Glyn Astill wrote:
> One thing I forgot to mention is that in the restore script I drop the
> indexes off my tables between restoring the schema and the data. I've always
> done this to speed up the restore, but is there any chance this could be
> causing the issue?
Uh. Why are you doing that
--- On Fri, 30/4/10, Alvaro Herrera wrote:
>
> Uh. Why are you doing that? pg_restore is
> supposed to restore the
> schema, then data, finally indexes and other stuff.
> Are you using
> separate schema/data dumps? If so, don't do that --
> it's known to be
> slower.
Yes, I'm restoring the s
Glyn Astill writes:
> The schema is fairly large, but I will try.
My guess is that you can reproduce it with not a lot of data, if you can
isolate the trigger condition.
> One thing I forgot to mention is that in the restore script I drop the
> indexes off my tables between restoring the schema
Do temp tables need to be explicitly dropped, or do the go away when the
process that created them leaves?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thom
On Fri, Apr 30, 2010 at 11:29 AM, Tom Lane wrote:
> Peter Hunsberger writes:
>> If all subscriptions are roughly equal in popularity then any single
>> select should give ~ 10% of the data. That would seem to be selective
>> enough that you'd really want an index?
>
> My personal rule of thumb i
In response to Geoffrey :
> Do temp tables need to be explicitly dropped, or do the go away when the
> process that created them leaves?
The latter one.
But explicitely delete them isn't an error.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Heade
Thank you very much for the quick answer !
I'm considering installing the upcoming 9.0 beta instead of 8.4.
Will it be available as an installable ubuntu 9.04 package ?
I have not tried to install a beta release before so I'm a bit worried about
crashing my
8.3.10 install which works now.
Is there
Vincenzo Romano wrote:
> This is not enterprise grade.
"Enterprise grade" is nothing but a buzzword. Oh, it's also a moving
target. We've been not enterprise grade for years, always one feature
behind (and strangely, the one lacking feature is always the one of
interest to the complainant).
--
I believe v9 will have native DB master/slave DB replication (correct if
wrong). If so, what's the best guess on when will v9 be released?
Thanks!
On Fri, Apr 30, 2010 at 2:17 PM, Gauthier, Dave wrote:
> I believe v9 will have native DB master/slave DB replication (correct if
> wrong). If so, what’s the best guess on when will v9 be released?
well, depends on how you define replication, but yes. my _guess_ on
release is late summer. the
On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave
wrote:
> I believe v9 will have native DB master/slave DB replication (correct if
> wrong). If so, what’s the best guess on when will v9 be released?
If I had to plan server deployments for the next year (and I do) I'd
be sticking with pg 8.3 and
>> On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave
>> wrote:
>>> I believe v9 will have native DB master/slave DB replication (correct if
>>> wrong). If so, what's the best guess on when will v9 be released?
>>
>> If I had to plan server deployments for the next year (and I do) I'd
>> be stick
On Fri, 2010-04-30 at 13:42 -0700, Gauthier, Dave wrote:
> >> On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave
> >> wrote:
> >>> I believe v9 will have native DB master/slave DB replication (correct if
> >>> wrong). If so, what's the best guess on when will v9 be released?
> >>
> >> If I had to
Alvaro Herrera wrote:
> Vincenzo Romano wrote:
>
> > This is not enterprise grade.
>
> "Enterprise grade" is nothing but a buzzword. Oh, it's also a moving
> target. We've been not enterprise grade for years, always one feature
> behind (and strangely, the one lacking feature is always the one
On Fri, Apr 30, 2010 at 2:38 PM, Raymond O'Donnell wrote:
> On 30/04/2010 21:30, Scott Marlowe wrote:
>> On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave
>> wrote:
>>> I believe v9 will have native DB master/slave DB replication (correct if
>>> wrong). If so, what’s the best guess on when will v
Ok I've been blatantly lying, err, purposely simplifying the problem for the
sake of the original email :)
I've read over the responses, and am actually now considering just not using
any index at all. Here's why:
First, this actually isn't the only thing on the WHERE clause. It will only
query
On Fri, Apr 30, 2010 at 00:19, Vincenzo Romano
wrote:
> For example, the Linux kernel made the big jump with server hardware
> thanks also to the O(1) schedulers.
Uhh linux has not had a O(1) scheduler since 2.6.23, its supposedly
O(log n) now. =)
--
Sent via pgsql-general mailing list (pgsql
Joshua D. Drake wrote:
On Fri, 2010-04-30 at 13:42 -0700, Gauthier, Dave wrote:
If I had to plan server deployments for the next year (and I do) I'd
be sticking with pg 8.3 and a proven replication engine. Next summer
Surely you mean 8.4? :-)
No, I would buy the 8.3 argume
Vincenzo Romano wrote:
I argued that O(n) stuff will keep it away from "enterprise grade" applications.
I've been told earlier that "It is fine for dozens of child tables,
but not thousands;
it does need improvement."
This is not enterprise grade
Enterprise grade doesn't mean anything. Partiti
2010/5/1 Greg Smith :
> Vincenzo Romano wrote:
>>
>> I argued that O(n) stuff will keep it away from "enterprise grade"
>> applications.
>> I've been told earlier that "It is fine for dozens of child tables,
>> but not thousands;
>> it does need improvement."
>> This is not enterprise grade
>
> Ent
49 matches
Mail list logo
