[GENERAL] Unsubscribe

unsubscribe

Re: [GENERAL] --//pgsql partitioning-///--------------------

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 and

Re: [GENERAL] how to return field based on field= NULL or not

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. I

Re: [GENERAL] Strange "missing tables" problem

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' tabl

Re: [GENERAL] Strange "missing tables" problem

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 pr

Re: [GENERAL] using COPY and PARTITON

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, cjm1010 wrote: hi~ I want to insert DATA by using the COPY making PARTITON TABLE. By the way, DATA is inse

Re: [GENERAL] Partition tables

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 l

Re: [GENERAL] Partition tables

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

[GENERAL] PG_Bulkloader (or other tools) and partitions

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 t

Re: [GENERAL] keeping track of function execution

Scott Marlowe wrote: On Sun, May 3, 2009 at 9:38 AM, Wojtek 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 mailing list

[GENERAL] keeping track of function execution

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 devices_

[GENERAL] Postgres+Apache+PHP (again, but in different setup)

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 c

[GENERAL] Postgres+Apache+PHP (again, but in different setup)

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 c

[GENERAL] Problems with \dt

'mytable' before. The binaries were got from ftp://xenium.pdi.net/pub/PostgreSQL/bindist/PostgreSQL-v6_3-Solaris_v2_6.gz Thanks in advance Wojtek Pietron