Re: [GENERAL] Performance question

2001-09-10 Thread Herbert.Liechti
On Mon, 10 Sep 2001, Tille, Andreas wrote: Hello, I have ported a database from MS SQL Server to PostgreSQL. The database has 40 tables and 117 indexes which I defined for the same fields as in MS SQL. I converted the data using some SQL output from MS SQL server and inserted it with

Re: [GENERAL] postgresql on SuSE 7.1 with reiserfs

2001-06-07 Thread Herbert.Liechti
On Thu, 7 Jun 2001, Jose Manuel Lorenzo Lopez wrote: Hello community, anyone experienced problems using postgresql distribution on SuSE 7.1 with reiserfs??? Yes without any problems. I noticed the following problem: When creating a table 'tableA' as User A I can not insert in this

Re: [GENERAL] triggering a procedure every X minutes

2001-06-06 Thread Herbert.Liechti
On Wed, 6 Jun 2001, Fran Fabrizio wrote: Some thoughts are: 1. It would be portable with the database. I don't have to go setting up crons on the new machine if I move the db. 2. The cron usually involves writing a shell/perl/whatever script to call the psql client and pass in SQL