Mon Sep 10 07:07:09 PDT 2007
- Previous message: [Slony1-general] Flakey network links
- Next message: [Slony1-general] size of requests stored in sl_log_x
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, We're hitting 400 requests per second and noticed that sl_log_? are growing a lot. This is also due to the fact that our tables have a lot of columns (more that 100). We noticed that slony stores each column and its value for each request in sl_log_x. Would it not be more optimized to store just the user request ? Actually, a user is just updating a few column, or inserting a tuple by giving some attributes but not all, however as slony stores every column with its value it sl_log_x, these tables are growing very fast :-( Another question : How logswitch is used in slony ? I try a logswitch.start() and I had to move date between sl_log_1 and sl_log_2 to finish it. How does it work ? which thread is using this function ? Regards. -- Cyril SCETBON
- Previous message: [Slony1-general] Flakey network links
- Next message: [Slony1-general] size of requests stored in sl_log_x
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list