On Mar 21, 2011, at 12:03 PM, preetika tyagi wrote:
> I tried running the same query after reboot and back-to-back, it was taking
> less time in both the cases. It means the problem is something else.
>
> Can there be a reason which is more hardware/operating system specific and
> due to which
Thank you, Scott!
I tried running the same query after reboot and back-to-back, it was taking
less time in both the cases. It means the problem is something else.
Can there be a reason which is more hardware/operating system specific and
due to which the behavior is not uniform?
Preetika
On Mon,
On Mar 21, 2011, at 9:55 AM, preetika tyagi wrote:
> For example, if A is 15 minutes, then B is 1.5 hrs.
Well, considering that random disk access is on the order of 10,000 times
slower than RAM...
But you can answer the question yourself by comparing the query run against
cold caches (after
Thank you, Vibhor!
I am wondering if caching will make such a big difference. For example, if A
is 15 minutes, then B is 1.5 hrs.
What could be other factors in case database server is separated from
clients (on different computer systems)?
Preetika
On Mon, Mar 21, 2011 at 2:48 AM, Vibhor Kumar
On Mar 21, 2011, at 10:42 AM, preetika tyagi wrote:
> Query: INSERT INTO table1 SELECT * FROM table2.
> Execution Time: A ms.
>
> Query: INSERT INTO table1 SELECT * FROM table2.
> Execution Time: B ms
If session is same, then
B < A if the data is cached due to execution of first statement.
B >
Hi,
I am wondering if someone can help me understand the following query
execution behavior:
I have two similar tables and table2 consists of 500 records.
Query: INSERT INTO table1 SELECT * FROM table2.
Execution Time: A ms.
Query: INSERT INTO table1 SELECT * FROM table2.
Execution Time: B
This is not exactly what I'm searching for, but thanks..
David
__
TL> David Hoksza <[EMAIL PROTECTED]> writes:
>> Hi, is there a way how to get some more detailed times for query
>> execution like Kernel Time, User Time and Process Time?
TL> See log_statement_stats and friends...
T
David Hoksza <[EMAIL PROTECTED]> writes:
> Hi, is there a way how to get some more detailed times for query
> execution like Kernel Time, User Time and Process Time?
See log_statement_stats and friends...
regards, tom lane
---(end of broadcast)
Hi, is there a way how to get some more detailed times for query
execution like Kernel Time, User Time and Process Time? I would like
see the time which PG really spends with computing without times from
another processes (I'm running on Windows with PostgreSQL 8.1.3.).
Thanks,
David Hoksza
