partition_add('mastertable', 'jan05', 'datecol between 20050101 and 20050131',
'tbsp1')
..could create the child table "mastertable_jan05" in tablespace tbsp1 together
with the needed rules, but new DDL syntax would of course be better still.
> Try doing a select against mastertab and you will see that it only
> selects from the correct partitions. Look at constraint_exclusion
> parameter, which needs to be set on for this to work.
Ah - constraint_exclusion is the correct param, not enable_constraint_exclusion
(as stated in http://www
Can anyone explain why the first one never completes, but the second one does?
(the first one just keeps running, I canceled after ~1 min)
PG version: 8.1 final
-- tblname param has type varchar
create or replace function getcolstring (tblname varchar) returns varchar as $$
declare
table_col
ovember 2005 19:56
To: Mikael Carneholm
Cc: 'Pgsql-General (E-mail)
Subject: Re: [GENERAL] Hanging creating of function
On Wed, Nov 09, 2005 at 07:38:53PM +0100, Mikael Carneholm wrote:
> Can anyone explain why the first one never completes, but the second
> one does? (the first one jus
005 16:46
To: Mikael Carneholm
Cc: 'Pgsql-General (E-mail)
Subject: Re: [GENERAL] Hanging creating of function
On Wed, Nov 09, 2005 at 08:19:32PM +0100, Mikael Carneholm wrote:
> Postgres machine OS: RHEL release 2.1 (Panama)
> PGAdminIII client OS: WinXP Pro 2002 SP2
> Clients: psql, P
and examples)
Hope you find it useful.
***
Mikael Carneholm
Systems Engineer
Service Delivery
WirelessCar
Address Kajskjul 107, Frihamnen, SE-417 07 Göteborg, Sweden
Phone + 46 31 65 19 57
Mobile + 46 703 22 29 57
Fax + 46 31 65 19 99
E-
Hi,
don't know if someone noticed my previous post, but here's now an updated
version of the script (see attachment)
Comments welcome.
/Mikael
part_functions.sql
Description: part_functions.sql
---(end of broadcast)---
TIP 6: explain analyze i
Hi,
is it possible to retrieve a list of queries that has caused the highest i/o
load? Something like
(1) select pg_stat_reset();
(2) run some queries for a while
(3) list the queries that caused the highest i/o since step (1)
?
/Mikael
---(end of broadcast)---
last pg_stat_reset()
select s.query_string, so.blks_read
from sometable s, someothertable so
where s.foo = so.foo
order by so.blks_read desc
limit 10;
/Mikael
-Original Message-
From: Jaime Casanova [mailto:[EMAIL PROTECTED]
Sent: den 14 november 2005 21:08
To: Mikael Carneholm
Cc:
>This looks like a good set of examples of how to set up custom partition
>management.
>Not sure whether a generic approach is that useful though, but maybe it
>could be a tech docs paper?
I was mainly into creating a single function that could set up insert/update
rules/functions for a parent
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free "database" in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
please, give me a reason not to get cynical...
> -Original Message-
>
I think you can use the binary string functions
(http://www.postgresql.org/docs/8.2/interactive/functions-binarystring.html) to
achieve the same as ReadText and UpdateText.
/Mikael
> -Original Message-
> From: Benedict Faria [mailto:[EMAIL PROTECTED]
> Sent: den 19 januari 2007 14:02
>
rrency: transaction isolation level,
MVCC vs. locking, and how they do when they test OLTP performance in
highly concurrent scenarios, and I'm sure you'll get a "huh?" as an
answer.
Kids...
Mikael Carneholm
Systems Engineer
WirelessCar
I recommend Clay (http://www.azzurri.jp/en/software/clay/index.jsp).
It requires a JRE + Eclipse (as it is an eclipse plugin), but it is really nice
to work with and has built-in support for PostgreSQL DDL generation.
/Mikael
---(end of broadcast)---
Hi,
I wonder what features other users would like to see in the next version? (8.2)
The features I'd (very much) would like to see implemented are:
- "Top offender statistics"
In other DBMS:es there are functions that allow you to turn on a sort of
monitoring that can tell you, for a period of
>In terms of statistics we do have statistics and exhaustive logging that
>can provide you with all of that information. Is there something
>specific that
>the information already provided really doesn't give you?
Can you give an example query for "list all queries executed since 12.00 AM,
orde
>>
>> Too bad - I think that will keep a lot of potential users from
>> evaluating Pg as a serious alternative. Good or bad, decide for
>> yourself :)
>Why on earth should that be?
Citing Baldur Norddahl
(http://archives.postgresql.org/pgsql-general/2006-01/msg00597.php):
"I will also point out
> Sure, but it still means installing an external tool, which requires
> PHP, which isn't trivial to install in it's own right. And afaik there's
> still no way to find out how much IO each query did, how much CPU was
> spent, if any sorts overflowed, etc., etc.
Exactly my point, and thus the reas
We have used the pro*c program found in this discussion (for the exact
same purpose):
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:45902
0243348
It is *blazingly* fast, and creates CSV formatted files suited perfectly
for postgresql's COPY command. Dumping 40Gb of data, sendi
19 matches
Mail list logo
