Hi Simon,
Looks like a novel idea. I just want to confirm my
understanding of the proposal.
a) This proposal would work for the kind of table organizations which are
currently partitioned and maintained based on some kind of timestamp.
Consider one of the use-case. A large Retail firm
On Jan 3, 2008 8:54 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> I wrote:
> > Do we really need "fhour_t" and "fminute_t" on top of "fsec_t"?
> > This seems like a bad factorization ...
>
> After some more thought: I think that what's bugging me is that "fsec_t"
> is intended to denote "fractional sec
I wrote:
> Do we really need "fhour_t" and "fminute_t" on top of "fsec_t"?
> This seems like a bad factorization ...
After some more thought: I think that what's bugging me is that "fsec_t"
is intended to denote "fractional seconds". The other cases you have
here seem not to be intended to be "fr
"Warren Turkal" <[EMAIL PROTECTED]> writes:
> I have created the following patch in an effort to start cleaning up
> the timestamp datatype. Please let me know if something like this will
> help so that I know whether to keep going. BTW, it passes a "make
> check" AFAICT.
Do we really need "fhour_
Hello,
I have created the following patch in an effort to start cleaning up
the timestamp datatype. Please let me know if something like this will
help so that I know whether to keep going. BTW, it passes a "make
check" AFAICT.
Thanks,
wt
>From aa573956233e20da4f8230e9fddb936a92c7e814 Mon Sep 17
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 3 Jan 2008 14:53:56 -0800
Josh Berkus <[EMAIL PROTECTED]> wrote:
> Folks,
> We may or may not be having a PostgreSQL Day before OSCON (Josh,
> Selena?) but we'll keep people posted. But submit a talk today!
Yes the PostgreSQL Day is planned
On Jan 3, 2008 2:53 PM, Josh Berkus <[EMAIL PROTECTED]> wrote:
> We may or may not be having a PostgreSQL Day before OSCON (Josh, Selena?)
> but we'll keep people posted. But submit a talk today!
I'd love to have another PostgreSQL Day before OSCON.
Let's just do it.
We're working on East righ
Folks,
The Call for Papers for O'Reilly Open Source Conference is open. Please
submit a talk if you can go to Portland!
Over the last 3 years, PostgreSQL has come to be the pre-eminent DBMS at
OSCON mainly through maintaining a really good booth and submitting really
good talks. Let's keep t
Greg,
Gregory Stark wrote:
I don't think DTrace is overkill either. The programmatic interface is
undocumented (but I've gotten Sun people to admit it exists -- I just have to
reverse engineer it from the existing code samples) but should be more or less
exactly what we need.
You probably k
Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
On Tue, 2008-01-01 at 16:09 -0500, Tom Lane wrote:
Paranoia would
suggest forbidding *any* form of ALTER TABLE when there are pending
trigger events, but maybe that's unnecessarily strong.
I disagree. This is
All,
Is there a place where I can find information about tuning postgresql
running on a Windows XP Pro 32 bit system? I installed using the binary
installer. I am seeing a high page fault delta and total page faults for
one of the postgresql processes. Any help would be great.
Doug Knight
WSI Corp
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Here is a narrowed down example.
In what locale/encoding? Can we see the pg_stats row for person_idx_3?
> PostgreSQL is version 8.1.9.
So it hasn't got the LIKE estimation fixes I put in two months ago ...
regards, tom lane
Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> On Tue, 2008-01-01 at 16:09 -0500, Tom Lane wrote:
>>> Paranoia would
>>> suggest forbidding *any* form of ALTER TABLE when there are pending
>>> trigger events, but maybe that's unnecessarily strong.
> I disagree. This is an implementation limitation
Am Freitag, 28. Dezember 2007 schrieb Tom Lane:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > I have been observing a case where the row count estimation for LIKE
> > 'foo' is (much) higher than for LIKE 'foo%', the rest of the query being
> > the same. This is a special case of the estimation
Kevin Grittner wrote:
If you really are doing proper maintenance, and you don't need exact
counts, you might be able to use the approximation stored in the
system tables:
Also, if you're using count(*) as an existance test (common in Mysql
code), it's better to use exists instead. Using
On Jan 3, 2008 7:39 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Sure, feel free to propose a specific ordering. I think you would need
> to take table size into account too.
Thanks, i thought we were already taking the database size into account
somewhat when we calculate the vacuum thresho
>>> On Wed, Jan 2, 2008 at 9:29 AM, in message
<[EMAIL PROTECTED]>, "Abraham,
Danny" <[EMAIL PROTECTED]> wrote:
> We are looking for a patch that will help us count using the indexes.
As others have mentioned, that's not currently possible for a count
of all rows in a table, because there can
On Thu, 2008-01-03 at 00:41 +, Sam Mason wrote:
> On Wed, Jan 02, 2008 at 05:56:14PM +, Simon Riggs wrote:
> > Like it?
>
> Sounds good. I've only given it a quick scan though. Would read-only
> segments retain the same disk-level format as is currently?
Yes, no changes at all to the
Usama Dar escribió:
> So wouldn't it make sense to pick up the tables in a similar order as well?
> like sorting the list on (deadtuples - calculated threshold) this way we
> will be vacuuming the tables in more need first.
Sure, feel free to propose a specific ordering. I think you would need
Simon Riggs wrote:
> On Tue, 2008-01-01 at 16:09 -0500, Tom Lane wrote:
>
> > Paranoia would
> > suggest forbidding *any* form of ALTER TABLE when there are pending
> > trigger events, but maybe that's unnecessarily strong.
>
> That works for me. Such a combination makes no sense, so banning it i
___
Support the World Aids Awareness campaign this month with Yahoo! For Good
http://uk.promotions.yahoo.com/forgood/
---(end of broadcast)---
TIP 5: don't forget to increase your
Gokulakannan Somasundaram wrote:
> Can you please explain, any specific use-case where DDLs are
> necessary within a transaction?
SQL-Scripts that create database objects and should either
succeed or have no effect.
Yours,
Laurenz Albe
---(end of broadcast)-
On Jan 3, 2008 3:53 PM, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> On Thu, Jan 03, 2008 at 01:08:47PM +0530, Gokulakannan Somasundaram wrote:
> > Can you please explain, any specific use-case where DDLs are necessary
> > within a transaction?
>
> I don't think they are ever necessary, the
On Thu, Jan 03, 2008 at 01:08:47PM +0530, Gokulakannan Somasundaram wrote:
> Can you please explain, any specific use-case where DDLs are necessary
> within a transaction?
I don't think they are ever necessary, they're just very very nice. For
example:
- You want a new column to appear populated
On Thu, Jan 03, 2008 at 01:08:47PM +0530, Gokulakannan Somasundaram wrote:
> On Jan 3, 2008 12:44 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > "Gokulakannan Somasundaram" <[EMAIL PROTECTED]> writes:
> > > I actually mean to say that DDLs can be declared as
> > > self-committing.
> >
> > Egad, an Ora
25 matches
Mail list logo
