stgres ( 8.0, I guess) and
samba. Workstations connect via odbc (informing the IP of server or the
name to connect the problem persists).
--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hi all,
I have PostgreSQL 8.1.4 running on a P 4 2.8 GHz , 512 MB with Linux
(Fedora Core 3)
The SQL comands below have a performance diference that I think is not
so much acceptable ( 1035.427 ms vs 7.209 ms ), since the tables isn´t
so much big ( contrato have 1907 rows and prog have 40.
Hi Dave,
Thanks to reply.
I run it now in a Postgres 8.1.4 my notebook (win XP) and the
performance is really much better:
EXPLAIN ANALYZE
SELECT Contrato.Id
, Min( prog.dtsemeio ) AS DtSemIni
, Max( prog.dtsemeio ) AS DtSemFim
, Min( prog.dtembarque ) AS DtEmbIni
, Max(
concerned about:
- I can create indexes on this temp table to optimize queries ?
If yes...
- This indexes will be destroyed together (automatic?) the temp table
when the connection is closed ?
- When I insert a lot of new rows, need to run analyze on this temporary
table ?
Thanks in Advance.
Adam PAPAI wrote:
Hi pgsql-performance,
I've a problem with the select * on a small table.
See below:
x7=# SELECT count(idn) from megjelenesek;
count
---
162
(1 row)
Why does it take cca 18-20 sec to get the results?
Too many indexes?
You likely have a huge amount of dead rows. T
