pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTemporary tables
6+ messages / 5 participants
[nested] [flat]
* Temporary tables
@ 2004-08-05 14:33 G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
2004-08-05 15:37 ` Re: Temporary tables Gaetano Mendola <mendola@bigfoot.com>
2004-08-05 15:41 ` Re: Temporary tables Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 2 replies; 6+ messages in thread
From: G u i d o B a r o s i o @ 2004-08-05 14:33 UTC (permalink / raw)
To: pgsql-performance@postgresql.org; +Cc: pgsql-admin
The box:
Linux 2.4.24-ck1
8 Intel(R) Xeon(TM) MP CPU 2.80GHz
4 gb RAM.
Postgresql 7.4.2
The problem:
Short in disk space. (waiting new hard)
The real problem:
Developers usually write queries involving the creation of temporary tables.
The BF question:
Is a good idea to link this tmp tables to another partition?
If so, how can I link this tmp tables to another partition?
Suggestions?
Thanks in advance!
Guido
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Temporary tables
2004-08-05 14:33 Temporary tables G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
@ 2004-08-05 15:37 ` Gaetano Mendola <mendola@bigfoot.com>
1 sibling, 0 replies; 6+ messages in thread
From: Gaetano Mendola @ 2004-08-05 15:37 UTC (permalink / raw)
To: G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
G u i d o B a r o s i o wrote:
> The box:
> Linux 2.4.24-ck1
> 8 Intel(R) Xeon(TM) MP CPU 2.80GHz
> 4 gb RAM.
> Postgresql 7.4.2
>
> The problem:
> Short in disk space. (waiting new hard)
>
> The real problem:
> Developers usually write queries involving the creation of temporary tables.
I seen too this behavior, till I explained that this is a valid sql:
select T.* from ( select * from table t where a = 5 ) AS T join foo using ( bar );
show us a typical function that use temporary tables.
Regards
Gaetano Mendola
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Temporary tables
2004-08-05 14:33 Temporary tables G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
@ 2004-08-05 15:41 ` Gaetano Mendola <mendola@bigfoot.com>
1 sibling, 0 replies; 6+ messages in thread
From: Gaetano Mendola @ 2004-08-05 15:41 UTC (permalink / raw)
To: G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>; pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
G u i d o B a r o s i o wrote:
| The box:
| Linux 2.4.24-ck1
| 8 Intel(R) Xeon(TM) MP CPU 2.80GHz
| 4 gb RAM.
| Postgresql 7.4.2
|
| The problem:
| Short in disk space. (waiting new hard)
|
| The real problem:
| Developers usually write queries involving the creation of temporary tables.
I seen too this behavior, till I explained that this is a valid sql:
select T.* from ( select * from table t where a = 5 ) AS T join foo using ( bar );
show us a typical function that use temporary tables.
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD4DBQFBElSx7UpzwH2SGd4RAhnkAKDABtA1fZSCCF/WAP5TUBJnHdWHYACWLjjQ
LgncGg4+b0lPCQbafXVG6w==
=1f1i
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 6+ messages in thread
* Temporary Tables
@ 2005-06-20 15:20 Anjan Dave <adave@vantage.com>
2005-06-20 16:03 ` Re: Temporary Tables Scott Marlowe <smarlowe@g2switchworks.com>
2005-06-21 14:43 ` Re: Temporary Tables David A. Leedom <daleedom@hightowergroup.com>
0 siblings, 2 replies; 6+ messages in thread
From: Anjan Dave @ 2005-06-20 15:20 UTC (permalink / raw)
To: pgsql-admin
Hi,
A developer is trying to use a Temporary Table via the java based
application. The problem is following the temp table creation, he wants
subsequent queries to query the temp table, but they are not in the same
database session as the temp table. Is this something I can setup
somewhere in the config? I would appreciate any pointers/info I can
forward to him.
Thanks,
Anjan
************************************************************************
******************
This e-mail and any files transmitted with it are intended for the use
of the
addressee(s) only and may be confidential and covered by the
attorney/client
and other privileges. If you received this e-mail in error, please
notify the
sender; do not disclose, copy, distribute, or take any action in
reliance on
the contents of this information; and delete it from your system. Any
other
use of this e-mail is prohibited.
************************************************************************
******************
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Temporary Tables
2005-06-20 15:20 Temporary Tables Anjan Dave <adave@vantage.com>
@ 2005-06-20 16:03 ` Scott Marlowe <smarlowe@g2switchworks.com>
1 sibling, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2005-06-20 16:03 UTC (permalink / raw)
To: Anjan Dave <adave@vantage.com>; +Cc: pgsql-admin
On Mon, 2005-06-20 at 10:20, Anjan Dave wrote:
> Hi,
>
>
>
> A developer is trying to use a Temporary Table via the java based
> application. The problem is following the temp table creation, he
> wants subsequent queries to query the temp table, but they are not in
> the same database session as the temp table. Is this something I can
> setup somewhere in the config? I would appreciate any pointers/info I
> can forward to him.
His usage suggests he should be using a regular table, possibly with
some kind of clean up / setup user defined functions associated with it.
The whole idea of temporary tables is that they allow you to write a
single client that declares a single table by name, and then you can run
that client any number of times, and each will not interfere with the
other. Generally, trying to share temp tables across different backends
is a bad idea, since the original session that created it might exit and
it would cease to be.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Temporary Tables
2005-06-20 15:20 Temporary Tables Anjan Dave <adave@vantage.com>
@ 2005-06-21 14:43 ` David A. Leedom <daleedom@hightowergroup.com>
1 sibling, 0 replies; 6+ messages in thread
From: David A. Leedom @ 2005-06-21 14:43 UTC (permalink / raw)
To: Anjan Dave <adave@vantage.com>; pgsql-admin
Anjan,
I would be very interested in this feature as well. However, my
understanding is that you must keep the connection open AND your
application must retain the SAME connection between database interactions.
The only way that I have done this is by creating a Session ID column to
your table of interest and make it a permanent table. The application then
maintains the Session ID in memory and uses it to segregate the data from
various users.
My main interest in this is to create my own user table which triggers on
other tables will somehow use to know that a specific user is making a
change on a specific row(s).
How do others handle this issue?
Enthusiastically,
Dave Leedom
At 11:20 AM 6/20/2005, Anjan Dave wrote:
>Hi,
>
>A developer is trying to use a Temporary Table via the java based
>application. The problem is following the temp table creation, he wants
>subsequent queries to query the temp table, but they are not in the same
>database session as the temp table. Is this something I can setup
>somewhere in the config? I would appreciate any pointers/info I can
>forward to him.
>
>Thanks,
>Anjan
>
>
>******************************************************************************************
>This e-mail and any files transmitted with it are intended for the use of the
>addressee(s) only and may be confidential and covered by the attorney/client
>and other privileges. If you received this e-mail in error, please notify
>the
>sender; do not disclose, copy, distribute, or take any action in reliance on
>the contents of this information; and delete it from your system. Any other
>use of this e-mail is prohibited.
>******************************************************************************************
>
The Hightower Group, Inc.
Custom Software Solutions Designed To Fit Your Business Like A Glove.
165 West Airport Road, Suite B/Lititz, PA 17543
V:717-560-4002, 877-560-4002 x: 114
F:717-560-2825
www.hightowergroup.com
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2005-06-21 14:43 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-05 14:33 Temporary tables G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
2004-08-05 15:37 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-05 15:41 ` Gaetano Mendola <mendola@bigfoot.com>
2005-06-20 15:20 Temporary Tables Anjan Dave <adave@vantage.com>
2005-06-20 16:03 ` Re: Temporary Tables Scott Marlowe <smarlowe@g2switchworks.com>
2005-06-21 14:43 ` Re: Temporary Tables David A. Leedom <daleedom@hightowergroup.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox