Re: [HACKERS] Tablespaces

2004-02-26 Thread James Rogers
performance by allocating most of the memory to the buffer cache rather than leaving it to the kernel file cache. I'm actually fairly curious to see what the new buffer management scheme will mean in terms of real world performance and parameter tuning. -James Rogers [EMAIL PROTECTED

Re: [HACKERS] Sponsoring enterprise features

2003-11-21 Thread James Rogers
, which I will post to the pg-hackers list. It is all stuff previously determined to be doable within the current PostgreSQL framework, and just requiring some work that my company is willing to help pay for. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast

[HACKERS] Sponsoring enterprise features

2003-11-18 Thread James Rogers
doing this? Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread James Rogers
of this particular beast. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [HACKERS] Database Kernels and O_DIRECT

2003-10-15 Thread James Rogers
, it is the difference between middling performance in the typical case and highly optimal in just about every case. A database kernel lets you use an operating system in the way it likes to be used rather than using an API that you just happen to support. Cheers, -James Rogers [EMAIL PROTECTED

Re: [HACKERS] Database Kernels and O_DIRECT

2003-10-15 Thread James Rogers
On 10/14/03 11:31 PM, James Rogers [EMAIL PROTECTED] wrote: There is some abstraction in Postgres and the database is well-written, but it isn't written in a manner that makes it easy to swap out operating system or API models. It is written to be portable at all levels. A database kernel

[HACKERS] Architecture Roadmap?

2003-10-06 Thread James Rogers
questions: 1) Does anyone object to me working on these two areas? 2) What version target should I realistically be shooting for? Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space

Re: [HACKERS] Index/Function organized table layout

2003-10-04 Thread James Rogers
On 10/2/03 11:34 PM, Hannu Krosing [EMAIL PROTECTED] wrote: James Rogers kirjutas N, 02.10.2003 kell 23:44: Not exactly. What you are describing is more akin to partitioning or hash-organized tables i.e. sorting insert/update tuples to various pages according to some hash function. What I

[HACKERS] Uses for Index/Function organizing

2003-10-04 Thread James Rogers
tool in the tool belt. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Index/Function organized table layout

2003-10-02 Thread James Rogers
of time-series data stored in a table, with each series keyed to another table. The the typical tuple distribution creates pathological behaviors when buffer space becomes tight. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP

Re: [HACKERS] Index/Function organized table layout

2003-10-02 Thread James Rogers
. You could always markup the index that CLUSTER uses to keep track of good candidates (plus some additional structures), but the more I think about that, the more it looks like a nasty hack. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast

[HACKERS] Index/Function organized table layout

2003-10-01 Thread James Rogers
optimization), but I thought I would check with the people currently hacking on the system first, to see if there was a showstopper or if someone is already working on this. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4