A Dimecres 01 Febrer 2006 01:32, Rodrigo Madera va escriure:
> I am concerned with performance issues involving the storage of DV on
> a database.
>
> I though of some options, which would be the most advised for speed?
>
> 1) Pack N frames inside a "container" and store the container to the db.
>
On Feb 1, 2006, at 4:37 PM, Matthew T. O'Connor wrote:
As far I as I know, we are still looking for real world feedback.
8.1 is the first release to have the integrated autovacuum. The
thresholds in 8.1 are a good bit less conservative than the
thresholds in the contrib version. The con
Indeed there is: you can use an ARRAY constructor with SELECT. Here's
some PGPLSQL code I have (simplified and with the variable names shrouded).
SELECT INTO m
ARRAY(SELECT d FROM hp
WHERE hp.ss=$1
ORDER BY 1);
FERREIRA, William (VALTECH) wrote:
maybe t
matthew@zeut.net ("Matthew T. O'Connor") writes:
> I think the default settings should be designed to minimize the
> impact autovacuum has on the system while preventing the system from
> ever getting wildly bloated (also protect xid wraparound, but that
> doesn't have anything to do with the thres
On Wed, Feb 01, 2006 at 10:20:21AM -0500, Tom Lane wrote:
> "Marc Morin" <[EMAIL PROTECTED]> writes:
> > Do you mean it would be impossible to change the code so that existing
> > selects continue to use the pre-truncated table until they commit?
>
> Yes, because that table won't exist any more (a
On Wed, Feb 01, 2006 at 04:37:07PM -0500, Matthew T. O'Connor wrote:
> I think the default settings should be designed to minimize the impact
> autovacuum has on the system while preventing the system from ever
> getting wildly bloated (also protect xid wraparound, but that doesn't
> have anythi
Well, it tells you how many transactions per second it was able to do.
Do you have specific questions?
On Thu, Feb 02, 2006 at 12:39:59PM +0530, Pradeep Parmar wrote:
> Hi,
>
> I'm fairly new to PostgreSQL. I was trying pgbench , but could not
> understand the output . Can anyone help me out to u
> On Wed, Feb 01, 2006 at 04:37:07PM -0500, Matthew T. O'Connor wrote:
>> I think the default settings should be designed to minimize the impact
>> autovacuum has on the system while preventing the system from ever
>> getting wildly bloated (also protect xid wraparound, but that doesn't
>> have
On Mon, Feb 06, 2006 at 10:14:53PM -0800, Christopher Browne wrote:
> > On Wed, Feb 01, 2006 at 04:37:07PM -0500, Matthew T. O'Connor wrote:
> >> I think the default settings should be designed to minimize the impact
> >> autovacuum has on the system while preventing the system from ever
> >> get
