unsubscribe
shahrzad khorrami wrote:
hi all,
I have alot data that I have to isert them to db,...
Now I decide to use of partitioning
http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html
but problem here is how I can do something that when I insert data,
the master table remains empty
hi,
You may try checking:
SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers'
SELECT * FROM pg_catalog.pg_tables WHERE tablename = 'customers'
to what's the status of your table.
Regards,
foo
Denis BUCHER wrote:
Hello,
Small correction to my previous email :
I have a strange
Denis BUCHER wrote:
Hello,
It's even more strange :
why, looks logical to me :)
# \dt customers
Liste des relations
Schéma | Nom | Type | Propriétaire
+-+---+--
rma| customers | table | postgres
(1 ligne)
you have 1 'customers'
Hi,
I assume one field will always be NULL and one will always has data in it.
select coalesce(fieldA, fieldB) from table
Regards,
foo
Juan Backson wrote:
Hi,
In my table, I have fieldA and fieldB. At any point in time, only one
of these fields can have data in it. The other is NULL.
Hi,
I'd recommend coping directly to child tables (partitions). It's much
faster.
Regards,
foo
Scott Marlowe wrote:
I believe triggers can do it.
On Sun, Aug 9, 2009 at 11:15 PM, cjm1010cjm1...@naver.com wrote:
hi~
I want to insert DATA by using the COPY making PARTITON TABLE. By the
Michael Gould wrote:
I am considering whether or not to partition a few tables in our system.
The guide lines I read said that this could help when the size of a table
exceeds the amount of system memory. I'm wondering if this statement should
be table or database.
The way our system operates
Michael Gould wrote:
2. can you come up with a pattern you can use to segment your data into
smaller chunks (like weeks, months, ids) to create partitions reasonably
big but not huge
Yes, each location has their own specific location code.
good!
how many rows you will have per each
Hi,
I'm looking for solution to speed up my data load process. Currently, I
have up to 100 insert/second loaded to partitioned table and application
is inserting data directly to partitions (not to master table).
As a solution, I wanted to explore pg_bulkloader but as I understand it
needs
Scott Marlowe wrote:
On Sun, May 3, 2009 at 9:38 AM, Wojtek f...@twine.pl wrote:
(...)
You could raise notice and then tail the logs as it runs. Or the
other option mentioned of using dblink() works well too.
dblink did the trick, thanks guys!
foo
--
Sent via pgsql-general
Hi,
I have a question on transactions/isolation levels/etc...
In my PL/pgSQL function main loop goes through inventory list of active
devices, for each one executing processing applicable for given device,
like:
FOR i in --i is %rowtype
select device_id as device_id,
type as type
from
Hi all,
I've read everything in this subject you guys has discussed already
(including topic started by Max Zorloff) but I haven't found my answer yet.
I'm looking for hints on best configuration for my specific needs: I'm
having complied program written in C, which reads lots of data from
Hi all,
I've read everything in this subject you guys has discussed already
(including topic started by Max Zorloff) but I haven't found my answer yet.
I'm looking for hints on best configuration for my specific needs: I'm
having complied program written in C, which reads lots of data from
13 matches
Mail list logo