Ow Mun Heng wrote:
=> select code, subset, avg(value) from foo group by subset, code;
code | subset | avg
--++-
A| 3 | 98.
A| 1 | 20.
A| 4 | 98.
A| 0 | 98.000
On Thu, 2007-09-06 at 20:57 -0500, Michael Glaesemann wrote:
> On Sep 6, 2007, at 20:46 , Ow Mun Heng wrote:
> > I would believe performance would be better it being denormalised. (in
> > this case)
>
> I assume you've arrived at the conclusion because you have
> (a) shown
> that the performan
On Thu, 2007-09-06 at 21:53 -0400, Merlin Moncure wrote:
> On 9/6/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > Table is like
> >
> > create table foo (
> > number int,
> > subset int,
> > value int
> > )
> >
> > select * from foo;
> > number | subset | value
> > 111
> > 1
Nobody has any comments on this??
On Thu, 2007-09-06 at 12:22 +0800, Ow Mun Heng wrote:
> Table is like
>
> create table foo (
> number int,
> subset int,
> value int
> )
>
> select * from foo;
> number | subset | value
> 111
> 122
> 1310
> 1
On Wed, 2007-08-22 at 20:41 +0100, Richard Huxton wrote:
> Murali Maddali wrote:
> > This is what I am doing, I am reading the data from SQL Server 2005 and
> > dumping to out to Postgresql 8.2 database.
My 2 cents.. I'm doing roughly the same thing, but I'm using perl and
DBI to do it.
> Fastest
brian <[EMAIL PROTECTED]> writes:
> But that should mean that my prepared statement that contains an INSERT
> should be logged, yes? (8.1 issues notwithstanding)
> I ask because i've set log_statement to 'mod' but am not seeing any
> of my prepared statements in the log. INSERT, UPDATE, and friend
Hi,
according to
http://www.postgresql.org/docs/8.2/interactive/storage-toast.html:
EXTENDED allows both compression and out-of-line storage.
This is the default for most TOAST-able data types.
Compression will be attempted first, then out-of-line storage if the row
is still too big.
MAIN a
Tom Lane wrote:
brian <[EMAIL PROTECTED]> writes:
The docs (8.1) say the following about log_statement: -- snip --
... mod logs all ddl statements, plus INSERT, UPDATE, DELETE,
TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are
also logged if their contained command is of an a
On Sep 6, 2007, at 20:46 , Ow Mun Heng wrote:
On Thu, 2007-09-06 at 20:20 -0500, Michael Glaesemann wrote:
On Sep 6, 2007, at 19:58 , Ow Mun Heng wrote:
Don't denormalise the table?
Yes. Don't denormalize the tables.
I would believe performance would be better it being denormalised. (in
On 9/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Darek Czarkowski <[EMAIL PROTECTED]> writes:
> > It can not be the resource limit, it has to be something else. I assume thi=
> > s version of postgres is incompatible with RedHat ES 5. Changing to a newer=
> > version of postgres is not an option f
"Chris Browne" <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Gregory Stark) writes:
>
>> You can even do this with GROUP BY as long as the leading columns of
>> the ORDER BY inside the subquery exactly matches the GROUP BY
>> columns.
...
> Is there not some risk that the query planner might c
[EMAIL PROTECTED] writes:
> Relational database pioneer says technology is obsolete
> http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9034619
> kindlt explain how??
There are several spins relevant to this:
1. He's trying to sell His New Thing, and it certainl
On Thu, 2007-09-06 at 19:52 -0500, Michael Glaesemann wrote:
> On Sep 6, 2007, at 19:37 , Ow Mun Heng wrote:
>
> > Nobody has any comments on this??
>
> Don't do it.
don't do what?
Don't denormalise the table?
don't put them into arrays?
Thing is, end-result is always for them to be in 1 row a
On 9/6/07, Yudie Pg <[EMAIL PROTECTED]> wrote:
> Here I'm posting a function to convert array to records.
> any other suggestions are welcome
http://archives.postgresql.org/pgsql-general/2007-07/msg01240.php
http://people.planetpostgresql.org/merlin/index.php?/archives/4-fun-with-arrays.html
merl
Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Gregory Stark) writes:
>> In theory we can't promise anything about future versions of
>> Postgres but there are lots of people doing this already so if ever
>> this was lost there would probably be some new explicit way to
>> achieve th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/06/07 20:45, Chris Browne wrote:
> [EMAIL PROTECTED] ("Trevor Talbot") writes:
>> There's also a point in regard to how modifications are made to your
>> data store. In general, things working with text files don't go to
>> much effort to mainta
101 - 116 of 116 matches
Mail list logo
