pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow can i get record by data block not by sql?
2+ messages / 2 participants
[nested] [flat]
* How can i get record by data block not by sql?
@ 2011-10-03 13:52 姜头 <104186179@qq.com>
0 siblings, 1 reply; 2+ messages in thread
From: 姜头 @ 2011-10-03 13:52 UTC (permalink / raw)
To: pgsql-performance
How can i get record by data block not by sql?
I want to read and write lots of data by data blocks and write record to a appointed data block and read it.
so i can form a disk-resident tree by recording the block address. But i don't know how to implement in postgresql.
Is there system function can do this?
Can someone help me?? Thank you very very much!!!!1
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How can i get record by data block not by sql?
@ 2011-10-03 14:29 Ben Chobot <bench@silentmedia.com>
parent: 姜头 <104186179@qq.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ben Chobot @ 2011-10-03 14:29 UTC (permalink / raw)
To: "姜头" <104186179@qq.com>; +Cc: pgsql-performance
On Oct 3, 2011, at 6:52 AM, 姜头 wrote:
> How can i get record by data block not by sql?
>
> I want to read and write lots of data by data blocks and write record to a appointed data block and read it.
> so i can form a disk-resident tree by recording the block address. But i don't know how to implement in postgresql.
> Is there system function can do this?
> Can someone help me?? Thank you very very much!!!!1
It sounds like you should look into the COPY command, or, if you're adventurous, the pg_bulkload project. They might get you the speed you're after, if not quite the implementation. But if what you're really after is to manipulate the table files directly - and I'm not sure why that would be a goal in itself - then perhaps SQL isn't for you.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-10-03 14:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-10-03 13:52 How can i get record by data block not by sql? 姜头 <104186179@qq.com>
2011-10-03 14:29 ` Ben Chobot <bench@silentmedia.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