> random_page_cost = 0.5
Not likely. The lowest this value should ever be is 1, and thats if
you're using something like a ram drive.
If you're drives are doing a ton of extra random IO due to the above
(rather than sequential reads) it would lower the throughput quite a
bit.
Try a value of 2 fo
EXPLAIN
INSERT INTO public.historical_price ( security_serial_id, [7 fields of proprietary
data])
SELECT public.security_series.security_serial_id, [7 fields of data],
FROM obsolete.datadb_fix INNER JOIN (obsolete.calcdb INNER JOIN public.security_series
ON obsolete.calcdb.serial=public.security_
> "DM" == Dror Matalon <[EMAIL PROTECTED]> writes:
DM> which brings me back to my question why not make Freebsd use more of its
DM> memory for disk caching and then tell postgres about it.
Because this is a painfully hard thing to do ;-(
It involves hacking a system header file and recompil
I am putting together new server to deal
with huge burst loads of traffic. I have been reading up on performance
recommendations on the site and am interested to try a battery backed up ram
disks for the wal buffer. I would like to hear about types and brands of ram
disk you have tried
Litao Wu <[EMAIL PROTECTED]> writes:
> I will use gdb next time. What's this right way to
> get info as postgres owner?
$ gdb /path/to/postgres
gdb> attach PID-of-backend-process
gdb> bt
gdb> quit
You might try this for practice on any idle backend; it shouldn't af
Thank you, Tom!
We vacuum and reindex every night and
reindex typically took 30 minutes. Today,
it ran since 3AM, and has not finished till 8:30AM.
The email and its indexe sizes are:
tablename indexname size_kb reltuples
email 1292696 8.07905e+06
email e
Litao Wu <[EMAIL PROTECTED]> writes:
> We often experience with the problem that reindex
> cannot be finished in our production database.
> It's typically done with 30 minutes. However,
> sometimes, when there is another "COPY" process,
> reindex will not finish. By monitoring the CPU
> time rei
On Tue, 2004-06-08 at 08:36, Josuà Maldonado wrote:
> Hello Scott,
SNIP...
> > Your numbers show that you are tossing 659M and 314M against each other,
> > but I don't know if you're harvesting the whole set at once, or just a
> > couple row of each. Indexing help, or is this always gonna be a b
Hi,
We often experience with the problem that reindex
cannot be finished in our production database.
It's typically done with 30 minutes. However,
sometimes, when there is another "COPY" process,
reindex will not finish. By monitoring the CPU
time reindex takes, it does not increase at all.
Tha
On Tue, 2004-06-08 at 01:24, Russell Smith wrote:
> Dear All,
>
> I have a table with approximately 570k Rows.
>
>
> Table "filter.rules"
> Column | Type | Modifiers
> --++---
Hello Scott,
El 07/06/2004 4:47 PM, Scott Marlowe en su mensaje escribio:
OK, you have to ask yourself a question here. Do I have enough memory
to let both postgresql and the kernel to cache this data, or enough
memory for only one. Then, you pick one and try it out. But there's
some issues here
Manfred Koizar <[EMAIL PROTECTED]> writes:
> So statistics gathering for expressional indexes will be in 7.5, but I
> don't know about the state of the planner ...
Planner support is there too:
2004-02-16 19:52 tgl
* src/: backend/optimizer/path/costsize.c,
backend/optimizer/uti
You were right not to believe it. I had an update on a whole table that I
hadn't noticed. Thanks for debunking.
On Monday 07 June 2004 23:29, you wrote:
> Marcus Whitney <[EMAIL PROTECTED]> writes:
> > I have an instance where I have a series of pl/pgsql calls, that report
> > stat results to
On Thu, Feb 26, 2004 at 06:06:06PM -0500, Christopher Weimann wrote:
> On 02/26/2004-11:16AM, Dror Matalon wrote:
> > >
> > > effective_cache_size changes no cache settings for postgresql, it simply
> > > acts as a hint to the planner on about how much of the dataset your OS /
> > > Kernel / Dis
On Tue, 8 Jun 2004 17:24:36 +1000, Russell Smith <[EMAIL PROTECTED]>
wrote:
>Also I am interested in how functional indexes have statistics collected for them, if
>they do.
Not in any released version.
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/analyze.c
| Revi
Dear All,
I have a table with approximately 570k Rows.
Table "filter.rules"
Column | Type | Modifiers
--++
rulename | character varying(16) | not null default ''::charac
16 matches
Mail list logo
