In a recent discussion with an academician friend of mine regarding how
to improve performance on a system, he came up with the idea of taking what
is now a monthly purge/cleanup job that takes about 24 hours (and growing)
and splitting it up into a series of smaller tasks.
That part's fairly eas
On Tue, Aug 23, 2005 at 12:27:39AM +0200, Ben-Nes Yonatan wrote:
> Jim C. Nasby wrote:
> >Emptying the cache will not show real-life results. You are always going
> >to have some stuff cached, even if you get a query for something new. In
> >this case (since you'll obviously want those indexes ther
> -Original Message-
> From: Ben-Nes Yonatan [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 22, 2005 3:28 PM
> To: Jim C. Nasby; Sean Davis; Dann Corbit
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Query results caching?
>
> > On Mon, Aug 22, 2005 at 10:13:49PM +0200, Ben-
On Mon, Aug 22, 2005 at 10:13:49PM +0200, Ben-Nes Yonatan wrote:
I think that I was misunderstood, Ill make an example:
Lets say that im making the following query for the first time on the
"motorcycles" table which got an index on the "manufacturer" field:
EXPLAIN ANALYZE SELECT manufacturer
am 22.08.2005, um 22:13:49 +0200 mailte Ben-Nes Yonatan folgendes:
I think that I was misunderstood, Ill make an example:
Okay:
Lets say that im making the following query for the first time on the
"motorcycles" table which got an index on the "manufacturer" field:
EXPLAIN ANALYZE SELEC
am 22.08.2005, um 22:13:49 +0200 mailte Ben-Nes Yonatan folgendes:
> I think that I was misunderstood, Ill make an example:
Okay:
> Lets say that im making the following query for the first time on the
> "motorcycles" table which got an index on the "manufacturer" field:
>
> EXPLAIN ANALYZE SE
> -Original Message-
> From: Ben-Nes Yonatan [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 22, 2005 1:14 PM
> To: Sean Davis; Dann Corbit
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Query results caching?
>
> Sean Davis wrote:
> > On 8/22/05 1:59 PM, "Dann Corbit" <[EMAI
On Mon, Aug 22, 2005 at 10:13:49PM +0200, Ben-Nes Yonatan wrote:
> I think that I was misunderstood, Ill make an example:
> Lets say that im making the following query for the first time on the
> "motorcycles" table which got an index on the "manufacturer" field:
>
> EXPLAIN ANALYZE SELECT manufa
Sean Davis wrote:
On 8/22/05 1:59 PM, "Dann Corbit" <[EMAIL PROTECTED]> wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Ben-Nes Yonatan
Sent: Monday, August 22, 2005 9:03 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Qu
On 8/22/05 1:59 PM, "Dann Corbit" <[EMAIL PROTECTED]> wrote:
>
>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Ben-Nes Yonatan
>> Sent: Monday, August 22, 2005 9:03 AM
>> To: pgsql-general@postgresql.org
>> Subject: [GENERAL] Qu
Laurent HERVE <[EMAIL PROTECTED]> writes:
> I would like to know if the PlPgSQL RAISE statement will be able to take
> expressions for the format string in 8.1.
As of CVS tip it still seems to want a literal string constant there.
regards, tom lane
--
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Ben-Nes Yonatan
> Sent: Monday, August 22, 2005 9:03 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Query results caching?
>
> Hi all,
>
> I dont know how its called but I
Hi all,
I dont know how its called but I noticed that when I query the db for
the first time it give me the result slower then the next times ill
repeat the same exact query, I figure that its some kind of caching so
henceforth the title of the mail :)
Anyway I would want to be able to delet
Nigel Horne schrieb:
On Mon, 2005-08-22 at 14:49, Tino Wildenhain wrote:
Nigel Horne schrieb:
On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
I can't work out from that how to return more than one value.
17:35 < rtfm_pl
Hi Michael,
Yes indeed, it is 7.4.8, and I will file a bugreport.
Op maandag 22 augustus 2005 15:21, schreef Michael Fuhr:
> On Mon, Aug 22, 2005 at 09:30:36AM +0200, Dick Kniep wrote:
> > [EMAIL PROTECTED]:/tmp> pg_restore -O -d cvix2 /tmp/dumpdb
> > pg_restore: [archiver (db)] could not execute
Apparently, PL/Ruby has an undocumented flag that you can pass it. :-)
http://rubyurl.com/Dz2 (usage)
http://rubyurl.com/t3S (install)
-Robby
--
/**
* Robby Russell, Owner.Developer.Geek
* PLANET ARGON, Open Source Solutions & Web Hosting
* P
On 22/8/05 2:56 pm, "Nigel Horne" <[EMAIL PROTECTED]> wrote:
> On Mon, 2005-08-22 at 14:49, Tino Wildenhain wrote:
>> Nigel Horne schrieb:
>>> On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
>>>
am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
> I can't work out fr
On 8/22/05 9:56 AM, "Nigel Horne" <[EMAIL PROTECTED]> wrote:
> On Mon, 2005-08-22 at 14:49, Tino Wildenhain wrote:
>> Nigel Horne schrieb:
>>> On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
>>>
am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
> I can't work out fr
On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
> am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
> > I can't work out from that how to return more than one value.
>
> 17:35 < rtfm_please> For information about srf
> 17:35 < rtfm_please> see
> http://techdocs.postgresql.org/guid
On Mon, 2005-08-08 at 15:30, Neil Conway wrote:
> Scott Marlowe wrote:
> > You might want to schedule analyzes to run every thirty minutes or every
> > hour.
>
> I doubt that is necessary or wise. Rerunning ANALYZE should only be
> necessary when the distribution of your data changes significan
There were two hints by readers about this yearweek issue at the 7.4.8 manual:
http://www.postgresql.org/docs/7.4/interactive/functions-datetime.html
The first by Daniel Grace 21 May 2004 0:39:19
CREATE OR REPLACE FUNCTION yearweek(TIMESTAMP WITH TIME ZONE)
RETURNS INT LANGUAGE plpgsql IMMUTABLE
Nigel Horne <[EMAIL PROTECTED]> writes:
> It strikes me that there are two problems with this approach:
> 1) It stores the return values in the database, that seems a waste
> 2) It's slightly more complicated in that I have to delete the
> return values from the previous call before inserting the
On Tue, 23 Aug 2005, Bernard wrote:
> Dear Postgresql specialists
>
> I would like to seek help with a SQL query that was developed and
> tested with other SQL92 compliant databases.
IIRC, allowing select items that are not in the group by but are
functionally dependant on the group by columns w
am 22.08.2005, um 14:56:09 +0100 mailte Nigel Horne folgendes:
> > > How does that help with my problem? I seems to discuss returning more
> > > than one row of a table which is not the question I asked.
> > >
> >
> > try to tell your questions more precisely :-)
>
> I want to return more than
On Mon, 22 Aug 2005, Nigel Horne wrote:
> On Fri, 2005-08-19 at 17:29, Tom Lane wrote:
> > Adam Witney <[EMAIL PROTECTED]> writes:
> > > Ah you want to return a record I suppose?
> >
> > > CREATE TABLE test (id int, name text);
> > > INSERT INTO test VALUES(1, 'me');
> > > INSERT INTO test VALUES
On Mon, 2005-08-22 at 14:49, Tino Wildenhain wrote:
> Nigel Horne schrieb:
> > On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
> >
> >>am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
> >>
> >>>I can't work out from that how to return more than one value.
> >>
> >>17:35 < rtfm_ple
Nigel Horne schrieb:
On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
I can't work out from that how to return more than one value.
17:35 < rtfm_please> For information about srf
17:35 < rtfm_please> see
http://techdocs.postg
On Mon, Aug 22, 2005 at 09:30:36AM +0200, Dick Kniep wrote:
>
> [EMAIL PROTECTED]:/tmp> pg_restore -O -d cvix2 /tmp/dumpdb
> pg_restore: [archiver (db)] could not execute query: ERROR: schema "Lindix"
> does not exist
What version of PostgreSQL are you using? I can duplicate this
problem with
am 23.08.2005, um 0:24:53 +1200 mailte Bernard folgendes:
> SELECT
> DEPARTMENT.PK,
> DEPARTMENT.NAME,
> MIN(PROJECT.VALUE)AS RATING
> FROM DEPARTMENT,
> PROJECT
> WHERE DEPARTMENT.PK=PROJECT.DEPARTMENT_FK
> GROUP BY DEPARTMENT.PK
> ORDER BY DEPARTMENT.PK;
>
> ERROR: column "department.na
On 8/22/05 8:24 AM, "Bernard" <[EMAIL PROTECTED]> wrote:
> Dear Postgresql specialists
>
> I would like to seek help with a SQL query that was developed and
> tested with other SQL92 compliant databases.
>
> Please examine the following testcase and the result that I get:
>
> # su postgres
> $
On 8/22/05, Pailloncy Jean-Gerard <[EMAIL PROTECTED]> wrote:
Hi,With PostgreSQL 7.4.6.I have a table aaa (id serial, maj timestamp without time zone)I defined to function from_timestamp and to_timestamp to doconversion between text and timestamp with few checks and tricks.
I defined a view aab (id
Dear Postgresql specialists
I would like to seek help with a SQL query that was developed and
tested with other SQL92 compliant databases.
Please examine the following testcase and the result that I get:
# su postgres
$ psql -d mydb -U postgres
CREATE TABLE DEPARTMENT(PK INT NOT NULL, NAME TEXT
I haven’t found any message on archives talking about
this, so I’m posting it.
The OCFS (Oracle Cluster File System) is now GPL – see
more on http://oss.oracle.com/projects/ocfs/
What do you think?
C ya,
Bruno
Hi,
With PostgreSQL 7.4.6.
I have a table aaa (id serial, maj timestamp without time zone)
I defined to function from_timestamp and to_timestamp to do
conversion between text and timestamp with few checks and tricks.
I defined a view aab (id serial, maj text) as "SELECT id,
from_timestamp(
Hi,
I would like to know if the PlPgSQL RAISE statement will be able to take
expressions for the format string in 8.1.
I checked the patches mailing list but I didn't find a clear answer.
I have to send error messages in several languages within PlPgSQL code.
I would like RAISE to work like that
On Mon, 2005-08-22 at 10:29, Adam Witney wrote:
> On 22/8/05 10:19 am, "Nigel Horne" <[EMAIL PROTECTED]> wrote:
>
> > On Fri, 2005-08-19 at 17:29, Tom Lane wrote:
> >> Adam Witney <[EMAIL PROTECTED]> writes:
> >>> Ah you want to return a record I suppose?
> >>
> >>> CREATE TABLE test (id int, nam
2005/8/21, Jim C. Nasby <[EMAIL PROTECTED]>:
> On Sun, Aug 21, 2005 at 08:00:45AM -0300, Clodoaldo Pinto wrote:
> > Of course it would be even better if we could pass parameters to the
> > functions changing its behavior such as sunday/monday as the first day
> > or 0-1 as the first day.
>
> FWIW,
On 22/8/05 10:19 am, "Nigel Horne" <[EMAIL PROTECTED]> wrote:
> On Fri, 2005-08-19 at 17:29, Tom Lane wrote:
>> Adam Witney <[EMAIL PROTECTED]> writes:
>>> Ah you want to return a record I suppose?
>>
>>> CREATE TABLE test (id int, name text);
>>> INSERT INTO test VALUES(1, 'me');
>>> INSERT INTO
Title: Re: [GENERAL] threads and transaction ...sample code and stored procedure
hi
everyone!
Thanks to Tom, the problem is fine ..The
mistake I was doing was setting the isolation level to
serializable.
and i have imposed an exclusive lock
instead of the access exclusive lock.
Thank
On Fri, 2005-08-19 at 17:29, Tom Lane wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
> > Ah you want to return a record I suppose?
>
> > CREATE TABLE test (id int, name text);
> > INSERT INTO test VALUES(1, 'me');
> > INSERT INTO test VALUES(2, 'you');
>
> > CREATE FUNCTION test_func() RETURNS
Hi list,
We have developed an application that makes extensive use of schema's in the
database. Some of the schemanames are uppercase, some are lowercase.
I make a backup using
pg_dump -f /tmp/dumpdb -F c -Z 5 cvix
When I try to restore this file, it fails with
[EMAIL PROTECTED]:/tmp> pg_res
41 matches
Mail list logo
