I changed the conf as you wrote. But now the time is changed from 50 sec to 65 sec. :(
I have not more 256 MB ram now.
When I execute the query the
Postmaster takes about 1.8 MB
Postgres session takes 18 MB ram only.
& psql takes 1.3 MB.
After the query finishes the
Postgres session reducess mem
Saleem Burhani Baloch wrote:
I changed the conf as you wrote. But now the time is changed from 50 sec to 65 sec. :(
I have not more 256 MB ram now.
When I execute the query the
Postmaster takes about 1.8 MB
Postgres session takes 18 MB ram only.
& psql takes 1.3 MB.
After the query finishes the
I can't get the following statement to complete with reasonable time.
I've had it running for over ten hours without getting anywhere. I
suspect (hope) there may be a better way to accomplish what I'm trying
to do (set fields containing unique values to null):
UPDATE requests
SET session = NUL
Hi!
Does PostgreSQL allow to create tables and indices of a single
database on multiple disk drives with a purpose of increase
performance as Oracle database does? If a symbolic reference is the
only method then the next question is: how can it be determined what
file is referred to what table and
Hi,
This is not going to answer your question of course but did you already try to do this
in 2 steps?
You said that the subquery itself doesn't take very long, so perhaps you can create a
temporary table based on the subquery, then in the update do a join with the temporary
table?
This might
Christopher Kings-Lynne wrote:
1- How can I lock a single record so that other users can only read
it. ??
You cannot do that in PostgreSQL.
How about SELECT ... FOR UPDATE?
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
---(end of broadcast)-
On Tuesday 17 February 2004 12:54, Konstantin Tokar wrote:
> Hi!
> Does PostgreSQL allow to create tables and indices of a single
> database on multiple disk drives with a purpose of increase
> performance as Oracle database does? If a symbolic reference is the
> only method then the next question
"Saleem Burhani Baloch" <[EMAIL PROTECTED]> writes:
> I have a question why MS-SQL with 256 MB RAM gives result in 2 sec ?? If I have low
> memory Postgres should give result in 10 sec as compared to MS-SQL.
Are you still running 7.1?
regards, tom lane
--
Hi All,
I’m really like this list. Thank you for all the invaluable
information! May I ask a question?
I’ve got a table with about 8 million rows and
growing. I must run reports daily off
this table, and another smaller one.
Typical query – joins, groupings and
aggregates includ
Easy two step procedure for speeding this up:
1: Upgrade to 7.4.1
2: Read this:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.po
On Tue, 17 Feb 2004, Konstantin Tokar wrote:
> Hi!
> Does PostgreSQL allow to create tables and indices of a single
> database on multiple disk drives with a purpose of increase
> performance as Oracle database does? If a symbolic reference is the
> only method then the next question is: how can i
> On Tue, 17 Feb 2004, Konstantin Tokar wrote:
>
>> Hi!
>> Does PostgreSQL allow to create tables and indices of a single
>> database on multiple disk drives with a purpose of increase
>> performance as Oracle database does? If a symbolic reference is the
>> only method then the next question is: h
> On Tue, 17 Feb 2004, Craig Thomas wrote:
>
>> > On Tue, 17 Feb 2004, Konstantin Tokar wrote:
>> >
>> >> Hi!
>> >> Does PostgreSQL allow to create tables and indices of a single
>> database on multiple disk drives with a purpose of increase
>> >> performance as Oracle database does? If a symbolic
On Tue, 17 Feb 2004, Craig Thomas wrote:
> > On Tue, 17 Feb 2004, Craig Thomas wrote:
> >
> >> > On Tue, 17 Feb 2004, Konstantin Tokar wrote:
> >> >
> >> >> Hi!
> >> >> Does PostgreSQL allow to create tables and indices of a single
> >> database on multiple disk drives with a purpose of increase
>
On Feb 17, 2004, at 10:06 AM, Todd Fulton wrote:
I’ve got a table with about 8 million rows and growing. I must run
reports daily off this table, and another smaller one. Typical query
– joins, groupings and aggregates included. This certain report takes
about 10 minutes on average and is g
Hey! I think I have appropriate indexes, but might now. You're
absolutely right on my join -- spk_tgplog has the 8.5 million rows,
spk_tgp around 2400. I'll try the sub-select. Here is the output you
asked for:
spank_prod=# \d spk_tgp;
Table "spk_tg
It seems, that if I know the type and frequency of the queries a
database will be seeing, I could split the database by hand over
multiple disks and get better performance that I would with a RAID array
with similar hardware. Most of the data is volatile
and easily replaceable (and the rest is ba
[EMAIL PROTECTED] (Konstantin Tokar) wrote:
> Hi!
> Does PostgreSQL allow to create tables and indices of a single
> database on multiple disk drives with a purpose of increase
> performance as Oracle database does? If a symbolic reference is the
> only method then the next question is: how can it
On Feb 17, 2004, at 1:41 PM, Todd Fulton wrote:
spank_prod=# \d idx_spk_tgp_tgpid
Index "idx_spk_tgp_tgpid"
Column | Type
---+---
tgpid | bigint
directoryname | character varying(64)
btree
A couple of things to note:
1. What version
"Todd Fulton" <[EMAIL PROTECTED]> writes:
> prod=# explain analyze SELECT t.tgpid, t.directoryname, t.templateid,
> count(*) AS requested FROM (spk_tgp t JOIN spk_tgplog l ON ((t.tgpid =
> l.tgpid))) GROUP BY t.tgpid, t.directoryname, t.templateid;
> NOTICE: QUERY PLAN:
> Aggregate (cost=274045
1- How can I lock a single record so that other users can only read
it. ??
You cannot do that in PostgreSQL.
How about SELECT ... FOR UPDATE?
No, because users cannot read the locked row in that case.
Chris
---(end of broadcast)---
TIP 7: don't
On Wed, 18 Feb 2004, Christopher Kings-Lynne wrote:
> >>> 1- How can I lock a single record so that other users can only read
> >>> it. ??
> >>
> >>
> >> You cannot do that in PostgreSQL.
> >
> >
> > How about SELECT ... FOR UPDATE?
>
> No, because users cannot read the locked row in that case
scott.marlowe wrote:
On Wed, 18 Feb 2004, Christopher Kings-Lynne wrote:
1- How can I lock a single record so that other users can only read
it. ??
You cannot do that in PostgreSQL.
How about SELECT ... FOR UPDATE?
No, because users cannot read the locked row in that case.
I just tested it (w
How about SELECT ... FOR UPDATE?
No, because users cannot read the locked row in that case.
I just tested it (within transactions) and it appeared that I could still
view the rows selected for update.
Ah, true. My mistake. OK, well you can do it in postgres then...
Chris
Eric Jain wrote:
> I can't get the following statement to complete with reasonable time.
> I've had it running for over ten hours without getting anywhere. I
> suspect (hope) there may be a better way to accomplish what I'm trying
> to do (set fields containing unique values to null):
[...]
> Usi
25 matches
Mail list logo