I chose to rebuild the entire table as I didn't really have the
necessary time to investigate what went wrong beyond of what I already did.
I have tried various scenarios for reproducing the problem but I failed
in doing that. The fact is that there were a large number of PGAdmin
crashes in the
Christian Schröder wrote:
> Alvaro Herrera wrote:
>> Christian Schröder wrote:
>>
>>
>>> I think it is my job as db admin to make the database work the way my
>>> users need it, and not the user's job to find a solution that fits the
>>> database's needs ...
>>>
>>> Is there really nothing tha
Hi,
When I use the statistics collector to see the number of IO, I always get
zero in almost all of columns. I really want to know the reason for that.
The result of statistics view:
# select * from pg_statio_user_tables;
relid | schemaname | relname | heap_blks_read | heap_blks_hit |
id
"Yinan Li" <[EMAIL PROTECTED]> writes:
> When I use the statistics collector to see the number of IO, I always get
> zero in almost all of columns. I really want to know the reason for that.
It sure sounds like you don't really have stats_block_level turned on.
Did you remember to SIGHUP the postm
On 9/21/07, Nikita The Spider The Spider <[EMAIL PROTECTED]> wrote:
> On 9/21/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> > "Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes:
> > > I'm seeing a problem where pg_dump takes at least 5 minutes to execute
> > > no matter what I ask it to dump --
"Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes:
> I think I found the problem. getTypes() calls findFuncByOid() twice
> for each item it sees. A comment at the top of findFuncByOid() says,
> "should hash this, but just do linear search for now". So that funtion
> is O(n)/2 where n = the
I wrote:
> "Nikita The Spider The Spider" <[EMAIL PROTECTED]> writes:
>> Thanks for your help! Given that this problem seems to be triggered by
>> a sort of edge case and the fix is non-trivial, I guess I should not
>> expect a new version of pg_dump soon?
> We might look into fixing it for 8.3, b
Hi,
Im trying to setup my postgresql database for user authentication.
I have managed to install the libnss-pgsql module with the help of the
following links below.
http://archives.postgresql.org/pgsql-general/2001-12/msg00760.php
http://archives.postgresql.org/pgsql-general/2001-12/msg00761.php
I've got 2 nearly identical SRFs to retrieve data from the DB(pg 8.2.4)
which goes something like this
= Function 1 ==
CREATE OR REPLACE FUNCTION hot(fromdate timestamp without time zone, todate
timestamp without time zone, code text[])
RETURNS SETOF trh_hot
On Thu, 2007-09-20 at 07:55 -0500, Ron Johnson wrote:
> On 09/20/07 05:43, Ow Mun Heng wrote:
> > hehe.. I'll end up running it on a low-end desktop w/ 1GB ram and a
> > celeron 2G processor w/ ~30GB data/month.
>
> I probably would too, if I wasn't half-way across the country from
> the DC.
Jus
On Sat, 2007-09-22 at 16:05 -0400, Robert Treat wrote:
> On Friday 21 September 2007 22:43, Merlin Moncure wrote:
> > On 9/21/07, Robert Treat <[EMAIL PROTECTED]> wrote:
> > > On Thursday 20 September 2007 18:38, Merlin Moncure wrote:
> > > > On 9/20/07, Collin <[EMAIL PROTECTED]> wrote:
> > > > >
On Tue, 2007-09-18 at 02:24 -0700, Trevor Talbot wrote:
> On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
>
> > > > CREATE OR REPLACE FUNCTION foo_func(fromdate timestamp, todate
> > > > timestamp, code text)
>
> > > > LANGUAGE 'sql' IMMUTABLE STRICT;
>
> > > But If I were to use ALIASINg, I
Tom Lane escribió:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > ! /* no need to allocate more space than we have pages */
> > ! maxtuples = LAZY_ALLOC_TUPLES * relblocks;
>
> Uh ... you need to guard against integer overflow in this calculation.
Done this way. I applied i
Ow Mun Heng wrote:
> how can I debug or diagnose where the issues lies? Explain analyse
> doesn't do much since this is a Function Scan anyway.
Take them out of the function and EXPLAIN ANALYZE them as plain SQL.
Note that you should take the parameters out of the literal, so you need
to do somet
On Mon, 24 Sep 2007, Ow Mun Heng wrote:
Just curious, Why would being half-way across the country got to do with
the server specs? Better specs - Less Issues? :-)
I think he was referring to the management boards that x86 servers, not
low-end desktops, tend to provide, nowadays.
Derek E. Le
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/23/07 22:40, Ow Mun Heng wrote:
> On Thu, 2007-09-20 at 07:55 -0500, Ron Johnson wrote:
>> On 09/20/07 05:43, Ow Mun Heng wrote:
>
>>> hehe.. I'll end up running it on a low-end desktop w/ 1GB ram and a
>>> celeron 2G processor w/ ~30GB data/mon
On Mon, 2007-09-24 at 00:18 -0400, Alvaro Herrera wrote:
> Ow Mun Heng wrote:
>
> > how can I debug or diagnose where the issues lies? Explain analyse
> > doesn't do much since this is a Function Scan anyway.
>
> Take them out of the function and EXPLAIN ANALYZE them as plain SQL.
> Note that you
Ow Mun Heng wrote:
> Okay.. I tried that, but it seems like there's an issue w/ the CASE
> statements.
>
> When I tried the prepare w/
>
> AND (CASE WHEN $3 IS NULL THEN true else d.code = any ($3) END)
> AND (CASE WHEN $4 IS NULL THEN TRUE else D.id = any($4) END)
>
>
> it ERRORs w/ could not
On Mon, 2007-09-24 at 02:31 -0400, Alvaro Herrera wrote:
> Ow Mun Heng wrote:
>
> > Okay.. I tried that, but it seems like there's an issue w/ the CASE
> > statements.
> >
> > When I tried the prepare w/
> >
> > AND (CASE WHEN $3 IS NULL THEN true else d.code = any ($3) END)
> > AND (CASE WHEN $
19 matches
Mail list logo
