On Apr 20, 2011, at 4:08 AM, SUBHAM ROY wrote:
> Suppose Postgres is installed in two computers C1 & C2.
> C1 have some database tables. How can I copy these database tables from C1 to
> C2.
> I mean to say that can I copy tables from postgres installed in one m/c to
> another m/c.
> Is there
Suppose Postgres is installed in two computers C1 & C2.
C1 have some database tables. How can I copy these database tables from C1
to C2.
I mean to say that can I copy tables from postgres installed in one m/c to
another m/c.
Is there any command in postgres to do so or any other short cut techniqu
SUBHAM ROY writes:
> I want to know how can we measure the execution time of a query in Postgres
> (Explain analyze will not do). Also is there any tools available in Linux
> for measuring the performance of queries of databases such as Oracle 11g,
> Postgres, etc.
> Any suggestions will be very h
t; Předmět: Re: [HACKERS] Needs Suggestion
> Datum: 27.3.2011 19:02:32
>
> Actually, I want to run some set of queries in postgres on a HUGE data set.
> I have to compute the actual execution time for each of those queries. So
> how can I do that
In these (Postgres) mailing lists, top-posting is not preferred. See my
response below.
On Sun, Mar 27, 2011 at 1:01 PM, SUBHAM ROY wrote:
>
> On Sun, Mar 27, 2011 at 10:20 PM, Gurjeet Singh
> wrote:
>
>> On Sun, Mar 27, 2011 at 9:22 AM, SUBHAM ROY wrote:
>>
>>> Hi,
>>> I am currently a studen
Actually, I want to run some set of queries in postgres on a HUGE data set.
I have to compute the actual execution time for each of those queries. So
how can I do that in Postgres ?
Suppose in Oracle following thing can be done :
*
set timing on;
select stuff from mytab;
Elapsed: 00:00:02.82
*Li
On Sun, Mar 27, 2011 at 9:22 AM, SUBHAM ROY wrote:
> Hi,
> I am currently a student of IIT Bombay. I am doing a project on "Benchmark
> design". For that I need to measure the performance of various queries in
> databases.
> I want to know how can we measure the execution time of a query in Postg
Subham,
I would start with reviewing Prof Mike Stonebrakers and Dr Paula
Hawthorns paper http://portal.acm.org/citation.cfm?doid=582095.582097
you can also look at Perftrack
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.101.7063&rep=rep1&type=pdf
regards
3dmashUp
On 3/27/2
Hi,
I am currently a student of IIT Bombay. I am doing a project on "Benchmark
design". For that I need to measure the performance of various queries in
databases.
I want to know how can we measure the execution time of a query in Postgres
(Explain analyze will not do). Also is there any tools avai
On 09/22/2010 05:03 AM, sub...@cse.iitb.ac.in wrote:
Actually, I used palloc() to set the stack base address.
And I am trying to create only a single thread, then also it is causing
problem.
Did you not understand when people told you this wasn't going to work?
Don't create any thr
So, Can I increase the stack depth limit to a large value ?
> On 22/09/10 12:03, sub...@cse.iitb.ac.in wrote:
>> Actually, I used palloc() to set the stack base address.
>> And I am trying to create only a single thread, then also it is causing
>> problem.
>> Actually, I created all the data-str
Actually, I used palloc() to set the stack base address.
And I am trying to create only a single thread, then also it is causing
problem.
Actually, I created all the data-structures using palloc(), then I am
passing these to the child thread. Even if I make these variables global
then also it is
sub...@cse.iitb.ac.in writes:
> How can I increase the stack depth limit ? Is it only by modifying the
> postgres.conf file, but there I cannot increase the stack depth beyond 4
> MB.
> Actually, my problem is that, when I set the stack base address of the
> child thread using the POSIX library fu
On 22/09/10 12:03, sub...@cse.iitb.ac.in wrote:
Actually, I used palloc() to set the stack base address.
And I am trying to create only a single thread, then also it is causing
problem.
Actually, I created all the data-structures using palloc(), then I am
passing these to the child thread. Even i
On 22/09/10 11:14, sub...@cse.iitb.ac.in wrote:
How can I increase the stack depth limit ? Is it only by modifying the
postgres.conf file, but there I cannot increase the stack depth beyond 4
MB.
Actually, my problem is that, when I set the stack base address of the
child thread using the POSIX
How can I increase the stack depth limit ? Is it only by modifying the
postgres.conf file, but there I cannot increase the stack depth beyond 4
MB.
Actually, my problem is that, when I set the stack base address of the
child thread using the POSIX library function "pthread_setstackaddr()", I
am u
On Mon, Aug 30, 2010 at 11:12 AM, wrote:
> Can anyone explain this ?
>
> My question is -
> What is lnext:; , lreplace:; in postgres code ?
> I found lnext:; in 1501 and lreplace:; in 2065 in execMain.c file.
It's a label.
http://www.lysator.liu.se/c/bwk-tutor.html#goto
--
Robert Haas
Enterpr
Can anyone explain this ?
My question is -
What is lnext:; , lreplace:; in postgres code ?
I found lnext:; in 1501 and lreplace:; in 2065 in execMain.c file.
--
Thank You,
Subham Roy.
CSE,
IIT Bombay.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
sub...@cse.iitb.ac.in writes:
> I need suggestion about how region based memory management is done in
> postgres.
Have you read src/backend/utils/mmgr/README ? It's old but still
reasonably accurate.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hacker
I need suggestion about how region based memory management is done in
postgres. I know the concept of region based memory management and also
know about the functions like memorycontextswitch().
But I am not understanding how Postgres uses hierarchical, region-based
memory management. That is I a
On Sat, Jul 3, 2010 at 1:04 PM, wrote:
> I am currently a student of IIT Bombay of CSE department. I am doing a
> project on postgres. I need to understand its code thoroughly, so I need
> "ddd" to "step through" its code. I need to start postgres on the
> "backend" mode to work it with "ddd".But
sub...@cse.iitb.ac.in wrote:
>
> Hi,
>
> I am currently a student of IIT Bombay of CSE department. I am doing a
> project on postgres. I need to understand its code thoroughly, so I need
> "ddd" to "step through" its code. I need to start postgres on the
> "backend" mode to work it with "ddd".But
Hi,
I am currently a student of IIT Bombay of CSE department. I am doing a
project on postgres. I need to understand its code thoroughly, so I need
"ddd" to "step through" its code. I need to start postgres on the
"backend" mode to work it with "ddd".But I am facing some difficulties in
setting u
23 matches
Mail list logo
