pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How 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>
  2011-10-03 14:29 ` Re: How can i get record by data block not by sql? Ben Chobot <bench@silentmedia.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 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>
  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