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
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
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,
Im really like this list. Thank you for all the invaluable
information! May I ask a question?
Ive 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
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?
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 it be
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 it
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 reference is the
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
performance as Oracle
On Feb 17, 2004, at 10:06 AM, Todd Fulton wrote:
Ive 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
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
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
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
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:
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
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
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):
[...]
Using
19 matches
Mail list logo
